创建联结

SELECT  vend_name, prod_name, prod_price
FROM vendors, Products
WHERE Vendors.end_id = Products.vend_id;

 

内联结

和上述代码结果一致

SELECT vend_name, prod_name, prod_price
FROM Vendors INNER JOIN Products
ON Vendors.vend_id = Products.vend_id;