View Single Post
  #7 (permalink)  
Old November 1st, 2005, 08:06 PM
robprell robprell is offline
Friend of Wrox
Join Date: Aug 2004
Location: Orange County, CA, USA.
Posts: 385
Thanks: 0
Thanked 0 Times in 0 Posts

Thanks your right I thought it would only order by on the second select, leaving the first in random order. It's the group by and agregations that require a temp table when trying to Union.