On 8/28/18, Joe <spec...@joepgen.com> wrote: > A (perhaps silly ) beginners question: > My sqlite database contains several tables, two of them, table A and > table B, have text colums called 'nam'. The tables have about 2 > millions lines. > What's the most efficient way to select all lines from table A with nam > values, which are not present in the nam values of table B?
I suppose: SELECT * FROM A WHERE nam NOT IN (SELECT nam FROM B); -- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users