Thank you sir
Igor Tandetnik wrote: > > 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 > > -- View this message in context: http://old.nabble.com/using-EXCEPT-with-UNION-tp26110941p26135714.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
