Re: Interesting Query Problem

2006-01-19 Thread Marco Neves
Hi, An alternative for any MySQL version (from 3.23.??) would be: SELECT r1.question_id,count(r1.member_id) FROM Records r1 LEFT JOIN Records r2 ON r1.question_id=r2.question_id AND r2.member_id= WHERE r2.question_id IS NULL;

Re: Interesting Query Problem

2006-01-19 Thread Gleb Paharenko
Hello. Perhaps this will work (depends on the version of MySQL you're using): select question_id , count(*) from Records group by question_id having question_id not in ( select distinct question_id from Records r wher