asked on
SQL Question for Inner join
Select * from OrderDetails inner join Products on Products.ProductID = OrderDetails.ProductID inner join Discounts on OrderDetails.DiscountID = Discounts.DiscountID where OrderID = 213
I'm trying to pull all the OrderDetails records where OrderID = 213.
Some OrderDetails records have Discounts (and a Discount ID)
If no discount has been applied to the OrderDetails, the value for DiscountID is Null.
I need to pull OrderDetails for ALL records for OrderID 213 - even those with a NULL value for DiscountID.
I would appreciate any help sorting out this query. right now it's returning 1 record, it should return 6.
Thanks for your help!!!
Steve
Microsoft SQL ServerSQL
Last Comment
slightlyoff
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
^^^ Jose is very likely correct. Since we can't access this data source and run queries, you'll have to run it yourself and verify.
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Thanks for your help - I apologize for the delay in responding.
The SQL I ended up using was: sql = "SELECT * FROM OrderDetails od full outer join products p on p.ProductID = od.ProductID full outer join Discounts d on od.DiscountID = d.DiscountID WHERE od.OrderID = " & theOrderID
The SQL I ended up using was: sql = "SELECT * FROM OrderDetails od full outer join products p on p.ProductID = od.ProductID full outer join Discounts d on od.DiscountID = d.DiscountID WHERE od.OrderID = " & theOrderID