Board index » delphi » Sort Record after using 'union' command

Sort Record after using 'union' command

Hi guy,

good day. Anyone of you know how to sort the record after using 'union'
command ? 'order by' giving me an error message.

Thank in advance

 

Re:Sort Record after using 'union' command


Lee,

This question isn't specific for IBX. Consider
borland.public.interbase.general in the future.

You can order a UNION by using column numbers, for example:

ORDER BY 3, 1 DESC, 2

-hh-

Quote
"lee" <leebanc...@hotmail.com> wrote in message news:3d477a58_2@dnews...
> Hi guy,

> good day. Anyone of you know how to sort the record after using
'union'
> command ? 'order by' giving me an error message.

> Thank in advance

Other Threads