Dear Alexandre/Arthur

I've posted the question to the wrong list, but you have already answered
me.

Thaks for yor help

Paulo Botelho

----- Original Message -----
From: "Alexandre Benson Smith" <iblist@...>
To: <firebird-support@yahoogroups.com>
Sent: Monday, May 10, 2004 1:38 PM
Subject: Re: [firebird-support] ODER BY após UNION ou UNION ALL


> Digirotas/Desenvolvimento wrote:
>
> >Pessoal,
> >
> >Preciso fazer um ORDER BY em um resultado de UNION...
> >
> >Ou seja, preciso ordenar todo o conjunto após o union.
> >
> >Alguém poderia me dar a dica de como fazer ?
> >
> >Obrigado
> >
> >Paulo Botelho
> >
> >
>
> Paulo,
>
> You should write in English on this list.
>
> Create a view with your select and union and then select from that view
> with an order by clause.
>
> create view vTest(ColumnA, ColumnB) as
> select
> ColumnA, Column B
> from
> TableA
> union all
> select
> ColumnA, Column B
> from
> TableB;
>
> select * from vTest order by ColumnA
>
>
> If you have problems to read English, contact me off-list I and can
> answer in portuguese.
>
> Caso tenha dificuldades em entender a mensagem em ingles, entre em
> contato comigo fora da lista e explico como resolver seu problema.
>
> see you !
>
> --
>
> Alexandre Benson Smith
> Development
> THOR Software e Comercial Ltda.
> Santo Andre - Sao Paulo - Brazil
> www.thorsoftware.com.br
>
>
>
>
> Yahoo! Groups Links
>
>
>
>
>