Re: [sqlite] using EXCEPT with UNION

[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 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

[sqlite] using EXCEPT with UNION

[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 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