Re: [sqlite] using EXCEPT with UNION

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: >> sele

Re: [sqlite] using EXCEPT with UNION

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

[sqlite] using EXCEPT with UNION

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