[SQL] set difference

[Domoszlai László]

Hello,

I would like to make symmetrical(set) difference in a query.
But the simpliest way I could find is 

select id from a 
except
select id from b
union 
select id from b
except
select id from a

Is there any better solution for this problem?

Thanks
Laca




---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
    (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])