SELECT a.* FROM tablea a left join tableb b on b.name = a.name WHERE isnull(b.name)
SELECT * from tablea WHERE name NOT IN(SELECT name from tableb)
>I get this situation alot and have not found an easy way to deal with it.
>
>Given the following situation: Table A contains the following data in field "name": Bill, Frank, Sany , James.
>
>And Table B contains the following data in field "name": Sandy, Frank
>
>Is there a sql statement that says give me everything in Table A that is not in Table B? So result the of the abocve example would be Bill, James
Alexandre Palma
Senior Application Architect