yeah but I've put it in just to show him that was possible cause usually if u use fields with index will be fast.
>>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
Alexandre Palma
Senior Application Architect