Fetching from 3 tables, with one condition on one table
I have 3 tables:
Order(OrderId,OrderDate,Firm,ConsumerId)
OrderProductDetails(OrderId,ProductId,Firm,Quantity,Rate,Fulfilled,PendingQuantity)
[fulfilled is boolean]
Product(ProductId,ProductName)
I want to fetch those orders (OrderId,OrderDate,ConsumerName) that are not
completely fulfilled. I tried a lot, but wasn't able to make it work. The
query seems simple, but I do not know how complex it is gonna be.
No comments:
Post a Comment