On 11 Jul, 09:10, CVH <me> wrote:
UNION always behaves like DISTINCT in any SQL implementation. That's
why there is also UNION ALL.
As the manual so clearly says (http://dev.mysql.com/doc/refman/5.0/en/
"The default behavior for UNION is that duplicate rows are removed
from the result. The optional DISTINCT keyword has no effect other
than the default because it also specifies duplicate-row removal. With
the optional ALL keyword, duplicate-row removal does not occur and the
result includes all matching rows from all the SELECT statements."
Don't know how you missed that when you were reading that section
before you posted here!