I am trying to combine data from two tables with identical structure into a sigle cursor for a report. I am having problems setting the order in the select statement.

select * from contribsplit;
having employer = m_combo1 and checkin = m_c2;
union ALL select * from csplithist;
having employer = m_combo1 and checkin = m_c2;
into cursor alan

Regardless of where I put the

order by ssn, deduction

seatement I get an error in the order by statement, If I drop the union select from the statement it works fine. What am I missing?