Thanks Jeremy, That was easy. - Ed >>> Jeremy March <[EMAIL PROTECTED]> 3/12/04 7:42:12 PM >>> > Can anyone tell me how to sort the combined results of a Union query? > > (Select Name From Employee Group By Name Order By Name) > Union (Select Name From Consultant Group By Name Order By Name); >
Just add another order by on the end after the parenthesis: (Select Name From Employee Group By Name Order By Name) Union (Select Name From Consultant Group By Name Order By Name) ORDER BY Name; -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
