Re: Sacego Sorting Problem

In article <bobbC9GDC0.KyC@netcom.com> bobb@netcom.com (Bob Beaulieu) writes: > >I can't seem to sort the below select by columns 1,2,3,4? The first is an ... >select A.as_budgunit,E.em_lastname,E.em_firstname,E.em_midname,E.em_empnum, > E.em_lgp,A.as_effdate,A.as_payrate,A.as_jobstep,A.as_retpd,A.as_fac, > A.as_reason,P.po_jobcode,P.po_jobtitle,X.as_payrate,X.as_retpd, > X.as_jobstep >from employee E,assignment A,position P,X >where A.as_effdate = "07/01/93" and P.po_repcode = "U" and A.as_enddate = > "123199" and A.as_empnum = X.as_empnum and A.as_empnum = E.em_empnum > and A.as_enddate = E.em_trmdate and A.as_jobcode = P.po_jobcode >order by 1,2,3;> Just as an experiment, I suggest you try: order by as_budgunit, em_lastname, em_firstname instead of "order by 1,2,3". My ACE reports sometimes seem to get confused when I order by column numbers, and then work OK if I substitute in the column names. Why this is I don't know, but it might be worth checking. Paul