I have two tables from two versions of the same database each table has an integer id primary key
I want to find the rows that dont appear in both tables. So I think I need a full outer join which I understand is not supported by SQLite I have seen this which gives an alternative, but it seems very complex http://en.wikipedia.org/wiki/Join_%28SQL%29#Full_outer_join Is there an easier way? and, I am sure this has been asked before, but out of interest why are full out joins not supported? _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users