select distinct
Or
use a union and make it distict.
Can you post your full query?
thines01
Postaholic
2,433 posts since Oct 2009
Reputation Points: 447
Solved Threads: 408
Skill Endorsements: 7
You can try
select name from Table2 where name not in (select * from Table1)
Reverend Jim
Carpe per diem
3,592 posts since Aug 2010
Reputation Points: 561
Solved Threads: 445
Skill Endorsements: 32