Re: SQL Bashing - the Sport of Champions!

Op woensdag 18 februari 2015 11:28:41 UTC+1 schreef Dieter Nöth:
> 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

Dieter,

"elaborations" by Mr. Pig Poop are not worth reading. They are biased by very questionable prejudices at best, hopelessly uninformed and outright wrong at worst.

One example : Mr. Pig Poop wrote "The notion of the Heading being tightly coupled to the column is a TTM absurdity. Complete pig poop. It doesn't happen in SQL, so in any case, it is silly to expect the non-feature here." I invite you to read up on SQL's UNION CORRESPONDING to see the evidence of the contrary. Received on Wed Feb 18 2015 - 15:01:13 CET