In article <[EMAIL PROTECTED]>, "AM Thomas" <[EMAIL PROTECTED]> writes:
> Now, if I understand how this is working: > SELECT r.TITLE > FROM resources r JOIN goals g ON (r.ID=g.RESOURCE_ID) > WHERE g.SUBJECT = 'English' > AND (g.GRADE = 1 OR g.GRADE = 2) > GROUP BY r.ID > HAVING COUNT(*) = 2; > will give an incorrect result, because the number of rows returned for > each matching ID will be unpredictable. It could be 7 rows for ID = > 1 (which is a correct match), or 3 rows for ID = 3 (which shouldn't > match since it only has grade 2). How about "HAVING count(DISTINCT g.grade) = 2"? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]