REPORTFORM;ABILL2_E.frf
TITLE;BILL RECEIPT INFORMATION REPORT
SQL;select billaptr.LINE, billaphd.BILLDATE, billaptr.DOCNO,
SQL;billaptr.DATEDOC, billaptr.DUEDATE, billaptr.AMOUNT_L,
SQL;billaphd.BDOCNO, billaphd.ACCID, apmst.XCOMP
SQL;from billaptr 
SQL;left join billaphd on billaptr.BDOCNO = billaphd.BDOCNO
SQL;left join apmst on billaphd.ACCID = apmst.ACCID
SQL;order by billaphd.BDOCNO, billaptr.LINE
CONDITION;FROM DOCUMENT~BILLAPTR.BDOCNO~Chr~2~SELECT BDOCNO FROM BILLAPTR ~
CONDITION;FROM DATE~BILLAPHD.BILLDATE~Date~2~~
