REPORTFORM;IV11.frf
TITLE;รายงานราคาสินค้า แต่ละลูกค้า
SQL;SELECT 
SQL;ARINVPR.accid,
SQL;ARMST.XCOMP,
SQL;ARINVPR.id,
SQL;INVMST.XDESC,
SQL;INVMST.XSGROUP,
SQL;IVGROUP.IVGDESC,
SQL;ARINVPR.PRICE,
SQL;ARINVPR.DISCL
SQL;FROM ARINVPR LEFT JOIN ARMST ON ARINVPR.accid = ARMST.ACCID
SQL;LEFT JOIN INVMST ON ARINVPR.id = INVMST.ID
SQL;LEFT JOIN IVGROUP ON INVMST.XSGROUP = IVGROUP.IVGID
SQL;ORDER BY ARINVPR.accid, INVMST.XSGROUP, ARINVPR.id
CONDITION;ตั้งแต่รหัสลูกค้า~ARINVPR.ACCID~Chr~2~SELECT ACCID FROM ARMST~AR
CONDITION;ตั้งแต่รหัสสินค้า~ARINVPR.ID~Chr~2~SELECT ID FROM INVMST~INV
