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