REPORTFORM;QUO7.frf
TITLE;รายงานใบเสนอราคาตาม รหัสพนักงาน วันที่
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;quo.XDESC, salemst.SNAME
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;order by quohead.SALEID, quo.DATEDOC, quo.DOCNO
SQL; 
CONDITION;ตั้งแต่รหัสพนักงาน~QUOHEAD.SALEID ~Chr~2~SELECT SID FROM SALEMST ~SALE
CONDITION;ตั้งแต่วันที่~QUO.DATEDOC~Date~2~~
