Hi, Please need your help in figuring out why this Oracle query does not work in SQLite : (select * from A minus select * from B) union all (select * from B minus select * from B)
I tried the same in SQLite: select * from A EXCEPT select * from B union all select * from B EXCEPT select * from B but it does not return the union, when I try to use parentheses it throws an error. -Thanks -- View this message in context: http://www.nabble.com/using-EXCEPT-with-UNION-tp26110941p26110941.html Sent from the SQLite mailing list archive at Nabble.com. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users