> -----Original Message----- > From: rudy [mailto:r937 at interlog.com] > > try this > > SELECT 'occurrences by product: ' > , PP.ppName > , COUNT(productTracking.id) > AS numberofoccurrences > FROM PossibleProducts PP > LEFT OUTER > JOIN productTracking PT > ON PP.id = PT.ptProduct > GROUP BY PP.ppName didn't seem to work (most likely my fault though). i get an error that says "Too few parameters. Expected 1." that usually suggests that something is spelled wrong. i checked it and eveything is correct. why do you do "AS numberofoccurrences" and then never use "numberofoccurrences" again? thanks for your help rudy. chris.