>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)
>

The first select cost you one minute <g> I thought of writing it too, hence the delay <g>

>>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