That is because only one ORDER BY clause is used in a UNION statement, ie: SELECT * FROM table1 WHERE cola = 'this' UNION SELECT * FROM table1 WHERE cola = 'that' ORDER BY colb DESC
V/r, Charles -------------------------------------------------- Charles Pelkey C.P Web Designs <[EMAIL PROTECTED]> http://www.cp-webdesigns.com/ ICQ: 8294384 MSN: cpwebdesigns Y!im: cp_designz Fax & voicemail: (928) 962-2939 ____________________________________________________________________________________ Need Mail bonding? Go to the Yahoo! Mail Q&A for great tips from Yahoo! Answers users. http://answers.yahoo.com/dir/?link=list&sid=396546091
