I think this will work as well:SELECT
P.person,
P.category,
P.item,
ISNULL(SUM(S.Qty), 0) AS Qty
FROM POSS AS P
LEFT OUTER JOIN Sales AS S
ON P.person = S.person
AND P.category = S.category
AND P.item = S.item
GROUP BY
P.person,
P.category,
P.item
ORDER BY
P.person,
P.category,
P.item;
Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)