Advertisement
Guest User

Untitled

a guest
Oct 31st, 2014
131
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.48 KB | None | 0 0
  1. SELECT c.CustomerID, c.CompanyName, o.OrderDate, p.ProductName, od.Quantity
  2. FROM Customers AS c
  3. INNER JOIN Orders AS o ON o.CustomerID=c.CustomerID
  4. INNER JOIN [ORDER Details] AS od ON od.OrderID=o.OrderID
  5. INNER JOIN [Products] AS p ON p.ProductID=od.ProductID
  6. WHERE c.CustomerID = 'ALFKI' OR c.CustomerID = 'VINET' OR c.CustomerID = 'HANAR' OR c.CustomerID = 'QUEDE'
  7. GROUP BY c.CustomerID, c.CompanyName, o.OrderDate, p.ProductName, od.Quantity
  8. ORDER BY o.OrderDate, od.Quantity DESC
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement