That did it, thank you all!
-Original Message-
From: Michael Stassen [mailto:[EMAIL PROTECTED]
Sent: Thursday, July 27, 2006 2:10 AM
To: Peter Lauri
Cc: mysql@lists.mysql.com
Subject: Re: WHERE problem, or is it a problem?
Peter Lauri wrote:
> Best group member,
>
> I have t
Use the HAVING clause:
SELECT part.memberid, part.prefname, part.email, COUNT(*) AS numberofans
FROM tblparticipants part
LEFT JOIN tblanswers answer ON (answer.par_num=part.memberid)
LEFT OUTER JOIN profilepdfauth pdfauth ON (part.memberid=pdfauth.memberid)
WHERE pdfauth.id IS NULL
GROUP BY part.
Peter Lauri wrote:
Best group member,
I have this query on MySQL version 4.0.27:
SELECT part.memberid, part.prefname, part.email, COUNT(*) AS numberofans
FROM tblparticipants part
LEFT JOIN tblanswers answer ON (answer.par_num=part.memberid)
LEFT OUTER JOIN profilepdfauth pdfauth ON (part.membe