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 <oliver....@web.de> wrote: From: Oliver Peters <oliver....@web.de> Subject: Re: [sqlite] Query to compare two sqlite databases To: sqlite-users@sqlite.org 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 sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
