Subject RES: [firebird-support] ORDER BY
Author Marcelo Pitanga
Hi, Cleber

Try

order by 2 ASC

> ----- Mensagem original -----
> De: Cleber Amaral [SMTP:clebercbr@...]
> Enviada em: sexta-feira, 6 de agosto de 2004 11:50
> Para: firebird-support@yahoogroups.com
> Assunto: [firebird-support] ORDER BY
>
> 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]
>
>
>
>
>
> Yahoo! Groups Links
>
>
>
>