Here I will post problems I and my colleagues met and solutions we found.

Tuesday, April 01, 2008

Aliases work in order clause in MS-SQL 2005

Not that I solved any problem but, today I accidentally found that aliases work in order clause if not used in functions. For example, this will work.

select c.Name, l.Value Lookup
from Customer c
left outer join LookupValue l on l.id = c.LookupId
order by Lookup

This didn't work in Oracle four years ago, where l.Value had to be used instead. And this is really nice.

1 comment:

Anonymous said...

Who knows where to download XRumer 5.0 Palladium?
Help, please. All recommend this program to effectively advertise on the Internet, this is the best program!