Re: SQL Bashing - the Sport of Champions!
From: Derek Asirvadem <derek.asirvadem_at_gmail.com>
Date: Wed, 18 Feb 2015 04:42:22 -0800 (PST)
Message-ID: <c2d088e0-c47b-4894-9e32-2580868e09ef_at_googlegroups.com>
Date: Wed, 18 Feb 2015 04:42:22 -0800 (PST)
Message-ID: <c2d088e0-c47b-4894-9e32-2580868e09ef_at_googlegroups.com>
> On Wednesday, 18 February 2015 21:28:41 UTC+11, Dieter Nöth wrote:
> Derek Asirvadem wrote:
> > I have UNION ALL, UNION nothing, and UNION DISTINCT.
> > They each return different results. Yours must be non-SQL.
>
> Could you elaborate on those different results, I always thought that
> UNION is the same as UNION DISTINCT (DISTINCT being simply the default).
Dieter
Of course you are right. I was typing faster than I was thinking.
Cheers