MySql多表查询

1、嵌套

select * from sell where vend_id in (
                     select vend_id from vendor where phoneNo > 100);

2、联结

select sell.* from sell, vendor where sell.vend_id = vendor.vend_id;