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!!!