Good day,
Are you looking to simply identify records that are different (not missing from the tables) or identify records with ANY field different and get the result? Is there a primary key? Posting the structure would be helpful. This should not be hard. C:\Documents and Settings\HP_Administrator>sqlite3 adam.db SQLite version 3.6.10 Enter ".help" for instructions Enter SQL statements terminated with a ";" sqlite> .tables sqlite> create table one (a int, b text); sqlite> create table two (a int, b text); sqlite> insert into one (a,b) values (1,'23); ...> '); sqlite> insert into one (a,b) values (2,'23'); sqlite> insert into one (a,b) values (3,'423'); sqlite> insert into one (a,b) values (5,'4423'); sqlite> insert into one (a,b) values (6,'4423'); sqlite> insert into two select * from one; sqlite> insert into one (a,b) values (4,'3423'); sqlite> insert into one (a,b) values (123,'3423'); sqlite> insert into two (a,b) values (123,'3423'); sqlite> insert into two (a,b) values (1233,'3423'); sqlite> select a,b from one where a not in(select a from two) ...> union all ...> select a,b from two where a not in(select a from one) ; 4|3423 1233|3423 sqlite> On Tue, Sep 29, 2009 at 12:38 PM, Petite Abeille <petite.abei...@gmail.com>wrote: > > On Sep 29, 2009, at 6:32 PM, Joe Bennett wrote: > > > Have two tables structured exactly the same. Want to compare both of > > them and get the delta. Been Googling for about an hour now and I see > > tools that do this (maybe a freeware one I haven't found?) and was > > looking for a solution that more meets the budget I was given for this > > project, zero... Any words of wisdom from the group at large on where > > to find how to do what I'm looking for or any examples? > > Have you consider union/minus/intersect? Very handy. And free. > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- VerifEye Technologies Inc. 905-948-0015x245 7100 Warden Ave, Unit 3 Markham ON, L3R 8B5 Canada _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
