On Tuesday 28 March 2006 10:05, Martijn van Oosterhout wrote: > That's because it's decribed in the SQL standard. UNION ALL just joins > the results of the two queries. UNION removes duplicates which usually > means sorting and comparing the tuples. UNION ALL is faster and usually > what you want anyway... Yes that's exactly what I want. Thanks for pointing out the difference
