Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT c.CustomerID, c.CompanyName, o.OrderDate, p.ProductName, od.Quantity
- FROM Customers AS c
- INNER JOIN Orders AS o ON o.CustomerID=c.CustomerID
- INNER JOIN [ORDER Details] AS od ON od.OrderID=o.OrderID
- INNER JOIN [Products] AS p ON p.ProductID=od.ProductID
- WHERE c.CustomerID = 'ALFKI' OR c.CustomerID = 'VINET' OR c.CustomerID = 'HANAR' OR c.CustomerID = 'QUEDE'
- GROUP BY c.CustomerID, c.CompanyName, o.OrderDate, p.ProductName, od.Quantity
- ORDER BY o.OrderDate, od.Quantity DESC
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement