Re: SQL query problem

Thanks for both replies, I'd finally managed to get a result from this

SELECT distinct person
  FROM table t1
 WHERE not exists (SELECT *

                      FROM table t2
                     WHERE t2.fruit In ('apple','peach')
                       and t1.person=t2.person)

So I'll take a look at all three versions and see which works fastest.

Thanks for your help both Sim and Isa

mike Received on Tue Jan 24 2006 - 02:42:25 CST