Path: news.netfront.net!news.unit0.net!news.mixmin.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:33:53 +0100 Organization: albasani.net Lines: 12 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 tH8/k5Z7KkzoXlhTTbiMM4qcsr0TgNxJgIQXcwaH5uNxupmxoXFnKgPL7mgaUBaqzODB6gH1QEiV/MxXrmexLA== NNTP-Posting-Date: Mon, 8 Aug 2016 12:33:38 +0000 (UTC) Injection-Info: news.albasani.net; logging-data="BnVChBlrWnleMkTRIlDmXwQ1seHVld123bckHvOlqCG9ahCrqI8dY/2R/AkX2j1ns4b8qnPyqSsoCI0hS/zFSxWC1REC6pbJFlrdtYdcJjm5S1Te46CeqX2mopnxt9FY"; 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:YRKcWPAWkI0dLngDc2j9nYoSb1A= Xref: news.netfront.net comp.databases.mysql:2729 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? > I cant find any reference to that keyword on googling the Mysql manuals of all versions. -- "I am inclined to tell the truth and dislike people who lie consistently. This makes me unfit for the company of people of a Left persuasion, and all women"