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.
SELECT OrderID, productid AS [1pID], suppID +‘ ‘+empID AS SuppEmp
FROM [ORDER DETAILS] AS details
ORDER BY productid, suppID +‘ ‘+empID