Thanks for any help given!

I have two tables. Orders, and OrderParts.

One Order can have many OrderParts.

I want a list of all the order.customerID where the number of OrderParts ordered = Total_number_parts in the order table.

Below is where i have got to so far, but where do i put the ‘where sum(partqty)=total_number_parts’ bit!!

Thanks very much, Simon

Select a.customerID, a.Total_number_parts

From Orders a

Join (Select sum(PartQty) from OrderParts Group by customerID) B on B.customerID = a.customerID

Group By a.CustomerID