And how do you define "not in"? For example, given the following:
Create table t1 ( Id integer primary key, Data text ); Create table t2 ( Id integer primary key, Data text ); Insert into t1 values (5, 'This is some data'); Insert into t2 values (5, 'This is some more data'); is the row (5, 'This is some data') IN t2 or NOT IN t2? -- The fact that there's a Highway to Hell but only a Stairway to Heaven says a lot about anticipated traffic volume. >-----Original Message----- >From: sqlite-users <sqlite-users-boun...@mailinglists.sqlite.org> On >Behalf Of Peng Yu >Sent: Wednesday, 18 September, 2019 09:50 >To: SQLite mailing list <sqlite-users@mailinglists.sqlite.org> >Subject: Re: [sqlite] How to do setdiff but update the original table by >the result? > >> I want to find all the rows in table1 that are not in table2 and then >delete those rows from table1. > >It is the above. > >-- >Regards, >Peng >_______________________________________________ >sqlite-users mailing list >sqlite-users@mailinglists.sqlite.org >http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users