REPORTFORM;SALEREG.frf
TITLE;ทะเบียนขาย
SQL;select arcard.DOCNO,arcard.DATEDOC,arcard.ACCID,armst.XCOMP,
SQL;arcard.SALEID,arcard.CUS_PO,arcard.ORDPONO,arcard.INVAMT,
SQL;arcard.VATAMT,arcard.AMOUNT_D
SQL;from arcard left join armst on arcard.ACCID = armst.ACCID
SQL;where trtype = 'AR1'
SQL;order by arcard.DOCNO
CONDITION;ตั้งแต่วันที่~ARCARD.DATEDOC~Date~2~~
