Is there a reason (other then it hasn't been implemented yet?) that the
following couldn't work?
SELECT id,count(id) AS cnt FROM table WHERE id IN ( 1,2,3,4,5)
GROUP BY id HAVING cnt = 2;
instead of:
SELECT id,count(id) AS cnt FROM table WHERE id IN ( 1,2,3,4,5)
GROUP BY id HAVING count(id) = 2;
The second one would have to 're-run' the COUNT against the table, would
it not? Whereas the first would take the existing results?
----
Marc G. Fournier Hub.Org Networking Services (http://www.hub.org)
Email: scrappy@hub.org Yahoo!: yscrappy ICQ: 7615664
