mchulet wrote: > 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.
Try this: select * from (select * from A EXCEPT select * from B) union all select * from (select * from B EXCEPT select * from A); Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
