Unanswered: Question on SQL Server2000's order by clause
I have problem of order by clase.
Must I specify the column in both select clause and order by clause
so as to get the correct result?
If I omit the order by column in select clause(for example:
select order.*, cl.ID from T_ORDER order, T_CLIENT cl where .... order by cl.code),
would MS SQL server 2000 still correctly or ignore order by clause completely?