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

Reply via email to