Path: news.netfront.net!news.unit0.net!eternal-september.org!feeder.eternal-september.org!news.eternal-september.org!jstuckle.eternal-september.org!.POSTED!not-for-mail From: Jerry Stuckle Newsgroups: comp.databases.mysql Subject: Re: Does MySQL support EXCEPT? Date: Mon, 8 Aug 2016 14:29:03 -0400 Organization: A noiseless patient Spider Lines: 13 Message-ID: References: <9c7debf9-c558-4c73-bf55-ee7001a422e8@googlegroups.com> Mime-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit Injection-Date: Mon, 8 Aug 2016 18:29:02 -0000 (UTC) Injection-Info: jstuckle.eternal-september.org; posting-host="8b88f1819ae50b8afa97a5cef254b303"; logging-data="6623"; mail-complaints-to="abuse@eternal-september.org"; posting-account="U2FsdGVkX1/MICxymBxxDR9geNZrMKXCSvKCW/ZvAtI=" User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:45.0) Gecko/20100101 Thunderbird/45.2.0 In-Reply-To: <9c7debf9-c558-4c73-bf55-ee7001a422e8@googlegroups.com> Cancel-Lock: sha1:N2rAUqt4pG4Rar4mO0Gka2+kjMI= Xref: news.netfront.net comp.databases.mysql:2731 On 8/8/2016 8:02 AM, 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? > Not as of the latest version (5.7). Maybe future versions will, but I wouldn't hold my breath. -- ================== Remove the "x" from my email address Jerry Stuckle jstucklex@attglobal.net ==================