O.Pieces AS 'Pieces On Order',
COUNT(P.OrderID) AS 'Parcels On Order'
FROM tblOrder AS O
LEFT OUTER JOIN tblParcel as P ON P.OrderID = O.OrderID
O.ReadyTimeFrom BETWEEN @Calendar1 AND @Calendar2 + 1
AND O.Status <> 4
O.OrderID, O.OriginName, O.Pieces, P.OrderID, O.ReadyTimeFrom
HAVING O.Pieces <> Count(*)
OR COUNT(P.OrderID) = 0
ORDER BY P.OrderID DESC
BTW, you can use the tags CODE and /CODE (each surrounded by square brackets) around your code and it will preserve your formatting. Click on "Forum Code" in the left hand window of the Quick Reply box for additional details.
The cure for anything is salt water -- sweat, tears, or the sea. -Isak Dinesen