Viewing post 1 (of 1 total)
For the same result you could try this:
select *
from tableA
where not exists (Select Field1
from TableB
where Field1=TableA.Field1)
January 10, 2006 at 1:39 am
#613737