The database is readonly and distributed on a CD and the search criteria
varie according to what my customers want to search for. So I can't create
a query. Is there a way to order the results without an query ?

At 01:02 PM 3/1/2004, you wrote:

>You can always create view:
>
>create view VIEW1 as
>SELECT .... blah blah blah
>UNION
>SELECT .... blah blah blah
>
>Then there is nothing more simple than
>select ... from VIEW1 order by Item1
>
>Regards,
>
>Marek
>
>Uwe Oeder wrote:
>
> >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
>
>
>
>