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