select distinct
Or
use a union and make it distict.
Can you post your full query?
thines01
Postaholic
2,424 posts since Oct 2009
Reputation Points: 445
Solved Threads: 402
You can try
select name from Table2 where name not in (select * from Table1)
Reverend Jim
Posting Shark
1,167 posts since Aug 2010
Reputation Points: 253
Solved Threads: 159