I am trying to combine into on table after collecting addition info, but I keep getting:
Command contains unrecognized phase / keyword.
sql order by invaild - when I remove the first order by line.

But when I run the two select statements seperately, I get the correct info.

SELECT qmf_temp.*, stops.stp_desc__ AS schl_desc FROM stops, stptrn, qmf_temp ; 
  WHERE stops.stop_id___ == stptrn.stop_id___ AND ;
        qmf_temp.fstop____2 = stptrn.fstop_id__ ;
        and inlist(qmf_temp.triptype__,1,3) ;
        order by studnt_id_, qmf_temp.stp_desc__, triptype__, program___ ;
union ;
SELECT qmf_temp.*, stops.stp_desc__ AS schl_desc FROM stops, stptrn, qmf_temp ; 
  WHERE stops.stop_id___ == stptrn.stop_id___ AND ;
        qmf_temp.fstop_____ = stptrn.fstop_id__ ;
        and inlist(qmf_temp.triptype__,2,4) ;
        order by studnt_id_, qmf_temp.stp_desc__, triptype__, program___ ;
into cursor qmf_all

TIA
Beth