Hello, The following query works for me.
select * from db2.table where not exists (select * from db1.table where db1.table.column1 = db2.table.column1); Thanks again for the assistance. --- On Fri, 9/24/10, Oliver Peters <[email protected]> wrote: From: Oliver Peters <[email protected]> Subject: Re: [sqlite] Query to compare two sqlite databases To: [email protected] Date: Friday, September 24, 2010, 2:54 PM Oliver Peters <oliver....@...> writes: sry > > the result is what is not in table01 > I meant: the result is what is in table01 but NOT in table02 Oliver _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
