Hi everyone,

Sorry for such novice question, but it got me stumped for a moment. How can I use ORDER BY clause for ORDER table? Also what is better: name every field like select company, OrderNumber from [ORDER] order by company, OrderNumber or select company, OrderNumber from [ORDER] order by 1,2 ?

Thanks in advance.