View Single Post
  #10 (permalink)  
Old November 2nd, 2005, 06:38 PM
Jeff Mason Jeff Mason is offline
Friend of Wrox
 
Join Date: Jun 2003
Location: Hudson, MA, USA.
Posts: 839
Thanks: 0
Thanked 1 Time in 1 Post
Default

Quote:
quote:Originally posted by robprell
 correct but I did say without sub selects.
Yes, and I originally responded to the ORDER BY question by stating that I didn't understand what you meant by the comment. I still don't.

What "sub selects" are you restricting from use?

Are you complaining that I used a derived table (of the UNION query) in order to use an aggregate? You are correct that you can't use an aggregate on the results of a UNION, but you stated that meant you needed a temp table; I merely pointed out an alternative to that.

Jeff Mason
Custom Apps, Inc.
www.custom-apps.com
Reply With Quote