Path: news.netfront.net!news.unit0.net!feeder.erje.net!1.eu.feeder.erje.net!news.albasani.net!.POSTED!not-for-mail From: The Natural Philosopher Newsgroups: comp.databases.mysql Subject: Re: Does MySQL support EXCEPT? Date: Mon, 8 Aug 2016 13:36:57 +0100 Organization: albasani.net Lines: 9 Message-ID: References: <9c7debf9-c558-4c73-bf55-ee7001a422e8@googlegroups.com> Mime-Version: 1.0 Content-Type: text/plain; charset=utf-8; format=flowed Content-Transfer-Encoding: 7bit X-Trace: news.albasani.net c7Dw0e1gvWzMu/8YhI/pK6M4qxxFaMplLArZPzAIphER+Bd+PmEPP+MUtbYgecBViLXK8eD78leBQcxSxK3M4w== NNTP-Posting-Date: Mon, 8 Aug 2016 12:36:43 +0000 (UTC) Injection-Info: news.albasani.net; logging-data="gT9OOjSS1TupXAhEhQIPN0ZhSQNrLi+Ec8mq8gtkDNHAxnLixo8HqygNlRMS7CANaUfz+FgAyVP5eEVgn722KN4TbM8q7zf77BT5h+MWIJvv723FzgQU9ZJeO9xnrRuJ"; mail-complaints-to="abuse@albasani.net" User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:45.0) Gecko/20100101 Thunderbird/45.2.0 In-Reply-To: <9c7debf9-c558-4c73-bf55-ee7001a422e8@googlegroups.com> Cancel-Lock: sha1:ff37c70EmPWoR8eK0eW0eE5NkV0= Xref: news.netfront.net comp.databases.mysql:2730 On 08/08/16 13:02, bit-naughty@hotmail.com wrote: > I've been reading on the web that it doesn't, you're supposed to use NOT IN instead, but these pages aren't new - do any of the latest versions of MySQL do EXCEPT? > also see http://stackoverflow.com/questions/16092353/error-when-using-except-in-a-query -- Gun Control: The law that ensures that only criminals have guns.