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
>