Query Help (Review)

[josh21]

Can someone help check if I solved this correctly:



1. This query should return customer items that have not shipped. This query should return the following fields: CustomerID, CustomerName, OrderID, ItemID, ItemDescription, OrderQuantity, and ShipQuantity. The query should return information for orders that have an OrderQuantity > 0 and a ShipQuantity < 1.

[June7]

Looks good to me. Does it return the records you expect?

[josh21]

Yes it does, I re-read the question more carefully. Thank you. Is it ok to add on to this topic for following question related to this assignment?

[June7]

Usually a new topic should have its own thread, but go ahead here.