Hello,

how I do an order by in the following case unless error:

select
table1.contador,
table2.Nome as NomeTable2
from
table1,
table2
where
table1.cdTable2 = table2.contador
order by
NomeTable2 ASC

When I use a "Alias" for table2.Nome

Someone knows?

thanks

Cleber


- - - - - - - - - - -
Cleber J. Amaral
- - - - - - - - - - -


---------------------------------
Lèche-vitrine ou lèche-écran ? Yahoo! Magasinage.


[Non-text portions of this message have been removed]