On Mon, 31 May 2004, George Ionescu wrote: > I think I have found a bug related to UNION SELECT; try this: > SELECT * FROM Test1 UNION SELECT * FROM Test2 > And I get only one record ? > Shouldn't I get two records, both having 1 value ?
You got the correct answer. A plain union will return exactly one copy of every unique row in the source queries. If you want all the rows to be returned, including duplicates, then you need to say "UNION ALL" instead of "UNION". -- Darren Duncan --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
