联结表

SELECT `vend_name`,prod_name , prod_price
FROM vendors,products
WHERE `vendors`.`vend_id` = `products`.`vend_id`
ORDER BY vend_name

不要忘记where，否则为笛卡尔积

内部联结

SELECT `vend_name`,prod_name , prod_price
FROM vendors INNER JOIN `products` 
ON vendors.`vend_id` = `products`.`vend_id`

联结多个表