> > select a.* from a where
> > not exists(select * from b where a.id = b.id)
>
> Yes, this should be equivalent and probably faster when there are

many

> duplicates on the person field.

Thanks for the info. Is there any perfomance difference between the
above query and:

select a.* from a where a.id not in (select id from b)

The plans look the same, but my test tables are too small to show any
difference is speed.

Thanks,

John