Webmaster Forum / ColdFusion / Advanced Techniques / December 2004

Not sure how to approach this, but I've got course numbers (columns num and
multinum) that I'm selecting from two different tables (Courses and
MultiCourse).  I want to be able to sort the two different course number
columns as if they were a single column.  I know my order clause below isn't
the way to go because it will treat the second sort as subordinate.    Do I
handle concatinating these two fields for a single sort by manipulating the
original select statement (below), or perhaps there is a way I can concatinate
output the two fields to a new query and sort from there?  Thanks a bunch and
happy holidays,  Chuck ------------------- code snippet below
--------------------------  SELECT     majorcourse.title, Courses.num as num,
MultiCourse.multinum as multinum FROM         majorcourse INNER JOIN            
           courses ON majorcourse.courseid = coursesid                        
                                      full outer JOIN                          
                                     multiCourse ON multiCoursecourseid =
coursesid                          ORDER BY Courses.num,MultiCourse.multinum