>> How can I use ORDER BY clause for ORDER table?

Since ORDER is listed as a reserve word, your safest approach will be to delimit the work with square brackets.


>> Also what is better

IMO, always be explicit.

-Mike

>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.