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
Go raibh maith agat
~M