While I think that often CPUs are given cruel treatment by us, this is a case where I'd abstain from formulating the query in 1 SQL statement unless "forced" by execution times being much shorter if using singular statement.
A sele * from unionedcursor order by is certainly unambiguos at the cost of doubled writing. Otherwise I'd argue for trying to find a SQL heavy on brackets that performs well - this should be safer if trying to run on another engine. And won't fool the author if read again 9 months later ;-)
>Hi all,
>the code below works but I need to add in an order by field1, field2 but I can't get it to work, I get an order by error. I've tried a simple order by command but no joy, also tried moving between engine behaviour 70/80/90 with no luck. Any help appreciated.
>~M
>
>
>sele FIELD_LIST ;
> from TBALE1 ;
> join TABLE2 ;
> join TABLE3 ;
> where something ;
> AND something else ;
> UNION ;
>sele FIELD_LIST
> from TBALE1 ;
> join TABLE2 ;
> join TABLE3 ;
> where something ;
> AND something else ;
> into cursor temp2 nofilter
>