REPORTFORM;QUO7_1.frf
TITLE;รายงานใบเสนอราคาตาม รหัสJOB วันที่
SQL;select quo.DATEDOC, quo.DOCNO, quohead.ACCID,
SQL;armst.XCOMP, quo.QTY, quo.UNIT_SAL, quo.PRICE,
SQL;quo.DISCL, quo.AMOUNT_L, quohead.SALEID, quo.ID,
SQL;invmst.XDESC, salemst.SNAME, quo.jobno, jobmst.jdesc
SQL;from quo 
SQL;left join quohead on quo.DOCNO = quohead.DOCNO
SQL;left join invmst on quo.ID = invmst.ID
SQL;left join salemst on quohead.SALEID = salemst.SID
SQL;left join armst on quohead.ACCID = armst.ACCID 
SQL;left join jobmst on quo.jobno = jobmst.jobno
SQL;order by quo.jobno, quo.DATEDOC, quo.DOCNO
SQL; 
CONDITION;ตั้งแต่รหัส Job~QUO.JOBNO~Chr~2~SELECT JOBNO FROM JOBMST~JOB
CONDITION;ตั้งแต่วันที่~QUO.DATEDOC~Date~2~~
