That doesn't seem to work either. After dropping and adding lines to the code, it seems that the comparison line is where it hiccups.

Here is an example where I get the columns to display side by side. Still, the HAVING is where I don't yet have it. If I omit the HAVING, the query runs fine.

SELECT

O.OrderID,

O.Pieces,

PA.OrderID,

COUNT(PA.OrderID) AS TotalParcels,

COUNT(*) AS 'TotalParcels'

FROM

tblParcelAssigned as PA

INNER JOIN

tblOrder AS O

ONO.OrderID = PA.OrderID

WHERE

PA.Type = 2

-- HAVING

-- o.Pieces <> Count(*)

GROUP BY

O.OrderID,

O.Pieces,

PA.OrderID

ORDER BY

PA.OrderID

DESC