Re: [sqlite] using EXCEPT with UNION

2009-10-30 Thread mchulet
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

[sqlite] using EXCEPT with UNION

2009-10-29 Thread mchulet
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