Facebook
From Unreliable Iguana, 4 Years ago, written in Plain Text.
This paste is a reply to Untitled from Harmless Cassowary - view diff
Embed
Download Paste or View Raw
Hits: 203
  1. SELECT od.OrderID, ProductID, CompanyName
  2. FROM Orders AS o
  3. JOIN order_details AS od
  4. ON o.OrderID=od.OrderID
  5. JOIN Shippers AS s
  6. ON o.ShipVia=s.ShipperID
  7. JOIN Products AS p
  8. ON od.ProductID=p.ProductID;