On Sep 29, 2009, at 6:50 PM, Cory Nelson wrote: > i believe he means except, not minus.
Correct. Got my SQL dialects intermingled :) > 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; And for the "fancy" join, something like: select * from bar left join foo on foo.id = bar.id where foo.id is null or foo.baz != bar.baz etc... As always, details might vary. _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
