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;