Coding multiple EXCEPTs
From: <bit-naughty_at_hotmail.com>
Date: Sun, 18 Sep 2016 23:56:53 -0700 (PDT)
Message-ID: <3f1feeac-86d8-4c39-88af-3370252cb6aa_at_googlegroups.com>
[Quoted] OK, so I found out from this group that MySQL doesn't have "EXCEPT", you have to use "NOT IN" - ie. "SELECT a EXCEPT b" is "SELECT b NOT IN a". But if I want MULTIPLE exceptions, ie. SELECT a EXCEPT b AND c AND d, ie. the result set of a minus each of the "b" and "c" and "d" - is this: SELECT b AND c AND d NOT IN a ?
Date: Sun, 18 Sep 2016 23:56:53 -0700 (PDT)
Message-ID: <3f1feeac-86d8-4c39-88af-3370252cb6aa_at_googlegroups.com>
[Quoted] OK, so I found out from this group that MySQL doesn't have "EXCEPT", you have to use "NOT IN" - ie. "SELECT a EXCEPT b" is "SELECT b NOT IN a". But if I want MULTIPLE exceptions, ie. SELECT a EXCEPT b AND c AND d, ie. the result set of a minus each of the "b" and "c" and "d" - is this: SELECT b AND c AND d NOT IN a ?
Aren't there some brackets needed somewhere or something? (like "(b AND c AND d)")?
Thanks. Received on Mon Sep 19 2016 - 08:56:53 CEST