On Tue, Sep 29, 2009 at 9:38 AM, 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.
i believe he means except, not minus. If all you need is differing rows, this will work like a charm. Otherwise if you need a more fine-grained delta like only returning columns that changed, you will need a more complex (but still pretty simple) join. SELECT * FROM t_foo EXCEPT SELECT * FROM t_bar; -- Cory Nelson http://int64.org _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
