Re: [sqlite] Query to compare two sqlite databases

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 wrote: From: Oliver Peters

Re: [sqlite] Query to compare two sqlite databases

Hello, Thanks for your response. I'm almost there but I keep getting sql syntax error (near col1) with the last part of the query where(not exists in db2); Here's where I'm at: select 'db1', db1.table1.col1, 'db2', db2.table2.col1 from db1.table1, db2.table2 WHERE (NOT EXISTS col1 IN db2);

[sqlite] Query to compare two sqlite databases

Hello, I compare an application every few days which has sqlite as it's client database. I look at the content and check whether documents have made it into the application after it has been built. I also check the metadata in the sqlite client database for changes. So, I am constantly