At 10:27 AM 26/05/2003 +0200, you wrote:

>Hi list,
>
>I found that an SQL statement like:
>
> select somefields
> from sometable
> where thisfield not in (select thistfield from thistable)
>
>is really slow when the tables have a high number of records. So is there
>any better alternative to this? (joins work well when the statement is
>"where X in", but how to do the same in a "not in" case?)

select a.fieldx, b.coly, ..., b.thisfield
from sometable a
left join thistable b
on a.thisfield = b.thisfield
where b.thisfield is null

heLen