Greetings! On Oct 16, 2004, at 17:19, Bradley Baetz wrote: ... > select bug_id from longdescs where bug_id in (SELECT id from > bugs where ....) GROUP BY bug_id HAVING count(*) > 1 > > In mysql you'll have to do it as a temp table + join. In MySQL version 4.0 or less, you will have to do it as a temp table and join. MySQL 4.1+ should support this syntax. Cheers! --zak