Re: SQL query problem

Hi, Mikeyb:
you can try the next:

select distinct person
from table t1
where 0=(select count(*) from table t2

              where t2.person=t1.person and fruit in ('Apple','Peach'));

I hope it's useful to you,
Regards,
Isa Received on Mon Jan 23 2006 - 11:42:31 CST