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 <[email protected]> On >Behalf Of Peng Yu >Sent: Wednesday, 18 September, 2019 09:50 >To: SQLite mailing list <[email protected]> >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 >[email protected] >http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
