March 13th, 2014, 02:45 AM
Join Date: Mar 2014
Time spent in forums: 26 m 53 sec
Reputation Power: 0
Sql Query Help!!!
List the order details where the quantity is between 65 and 70. Display the order id and quantity from the OrderDetails table, the product id and reorder level from the Products table, and the supplier id from the Suppliers table. Order the result set by the order id.
This is what I have got so far but ProductID, ReorderLevel and Supplier ID values are all NULL. the other two columns are fine.
FROM OrderDetails o
LEFT OUTER JOIN Products p ON o.OrderID = p.ProductID
LEFT OUTER JOIN Suppliers s ON p.SupplierID = s.SupplierID
WHERE Quantity BETWEEN 65 AND 70
Last edited by kristinat : March 13th, 2014 at 11:47 AM.