Have you tried something like this ?

SELECT 1, Item1, bla1, bla2 from table
Union
SELECT 2, Item1, bla3, bla4 from table
Order by 1, Item1

Pierre Y.

> -----Message d'origine-----
> De : Uwe Oeder [mailto:uweo@...]
> Envoyé : lundi 1 mars 2004 11:42
> À : firebird-support@yahoogroups.com
> Objet : [firebird-support] Unions
>
> Is it somehow possible to order the the product of a union ?
>
> SELECT .... blah blah blah
>
> UNION
>
> SELECT .... blah blah blah
>
> ORDER BY Item1
>
>
>
>
>
>
> Yahoo! Groups Links
>
>
>
>