O'Reilly logo
  • Ben Gray thinks this is interesting:

SELECT prod_name, vend_name, prod_price, quantity
FROM OrderItems, Products, Vendors
WHERE Products.vend_id = Vendors.vend_id
 

From

Cover of Sams Teach Yourself SQL in 10 Minutes, Fourth Edition

Note

INNER JOIN syntax for this code: SELECT prod_name, vend_name, prod_price, quantity FROM OrderItems INNER JOIN Products INNER JOIN Vendors ON Products.vend_id = Vendors.vend_id AND OrderItems.prod_id = Products.prod_id WHERE order_num = 20007;