On 29 Jul 2013, at 12:36pm, Fabian Klebert <f.kleb...@klebert-engineering.de> wrote:
> Wouldn't > > SELECT * FROM table1 > EXCEPT > SELECT * FROM table2 > > solve this problem? > I think it does for the example provided. Not sure if it would work in > real-world environment. There are two elements: making sure the same rows are present, and making sure the contents of the rows match. I would probably use EXCEPT commands to find out entries in one database which weren't in the other, then use INTERSECT command to check that the fields in the rows which were in both. But that's just at first glance. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users