Advertisement
Guest User

Untitled

a guest
Jan 24th, 2019
89
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 0.29 KB | None | 0 0
  1. SELECT Orders.OrderID, Customers.CustomerName, Products.ProductName, Products.Price
  2. FROM Orders
  3. JOIN Customers ON Orders.CustomerID=Customers.CustomerID
  4. JOIN OrderDetails ON Orders.OrderID=OrderDetails.OrderID
  5. JOIN Products ON OrderDetails.ProductID=Products.ProductID
  6. WHERE Orders.CustomerID=90
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement