ORDER BY

ORDER BY can use any amount of fields/ columns. Columns should be contained as expressions within the SELECT clause.
Table names, Column Names and Aliases are case insensitive and may contain an alphabetic character followed by alphanumeric -unless you put square brackets around the token, and then any character can be used. Names and aliases with a space also need to contained within square brackets.
Example:
SELECT OrderID, productid AS [1pID], suppID +' '+empID AS SuppEmpFROM [ORDER DETAILS] AS detailsORDER BY productid, suppID +' '+empID