Re: [sqlite] SQL for finding non-matching rows

[John LeSueur]

Clark Christensen wrote:

I've seen it described here before, but I can't seem to
find it.

select a from t1 where a not in (select b from t2);

will find the resultset I'm looking for, and it seems OK
when the resulting in () list is small (maybe < 1000).  But

it seems less than ideal when the resulting list is large. Isn't there a join I can do to accomplish the same a little

more elegantly?

Thanks!

-Clark

select a
from t1
   left outer join
       t2 on
           t1.a = t2.b
where
   t2.b is null

John