Terrific! Thanks to all who replied. -Clark
--- Kurt Welgehausen <[EMAIL PROTECTED]> wrote: > > 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 >
