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.
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
Subscribe to:
Post Comments (Atom)
1 comment:
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!
Post a Comment