On 8/28/18, Joe <[email protected]> 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 [email protected] _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
