>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

Select * From tableA where name not in (Select name from tableb)