Home Forums Article Discussions Article Discussions by Author Discuss content posted by Tariq Counts Puzzle RE: Counts Puzzle
brewmanz
SSCommitted
Points: 1575
More actions
August 26, 2008 at 4:53 am
#862995
ian treasure (8/26/2008)Shouldnt this be SELECT C.CATID, COUNT(*)FROM #DATA DINNERJOIN #CATEGORY C ON (C.VAL1 = DINNER.VAL1) OR (C.VAL1 IS NULL)GROUP BY C.CATID(was ON C.VAL1 = D.VAL1)
ian treasure (8/26/2008)
SELECT C.CATID, COUNT(*)
FROM #DATA DINNER
JOIN #CATEGORY C ON (C.VAL1 = DINNER.VAL1) OR (C.VAL1 IS NULL)
GROUP BY C.CATID
(was ON C.VAL1 = D.VAL1)
You must be like me ... always thinking of food 😉