Subject Re: Bug in firebird 1.5?? left joining
Author johnsparrowuk
> > select a.* from a where
> > not exists(select * from b where =
> Yes, this should be equivalent and probably faster when there are
> duplicates on the person field.

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

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

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