Re: [sqlite] SQL Query - finding rows in a table that are not present in another

On May 23, 2012, at 11:12 AM, Paul Sanderson wrote: > I need to return all of the rows in table B that are not present in table A You have at least 3 ways to express such a query: (1) Using 'in' select table_b.* fromtable_b where table_b.key not in ( select key from table_a ) (2)

[sqlite] SQL Query - finding rows in a table that are not present in another

I have a couple of table seach of which has one column but millions of rows, the column is a text column. I need to return all of the rows in table B that are not present in table A What is the most efficient way of doing this? ___ sqlite-users mailing