> > Am I right in thinking that UNION (without ALL) is defined to do a
> > DISTINCT on its result, so that duplicates are removed even if the
> > duplicates both came from the same source table? That's what 6.4.2
> > does, but I do not know if it's strictly kosher according to the SQL
> > spec.
(Just in case this is still active)
Yes, this is the right behavior according to SQL92...
- Thomas
--
Thomas Lockhart lockhart(at)alumni(dot)caltech(dot)edu
South Pasadena, California