> select a from t1 where a not in (select b from t2) select a from t1 except select b from t2
or (SQLite v3 only)
select a from t1 where not exists
(select b from t2 where b = a)
Which of these is fastest will probably depend on table
size and indexing; you'll have to try them out.
Regards
