REPORTFORM;invapprice1.frf
TITLE;รายงานแสดง ราคาซื้อสินค้า/ผู้จำหน่าย
SQL;SELECT
SQL;INVAPPRICE.ACCID, INVAPPRICE.ID, INVAPPRICE.LINE, INVAPPRICE.COST, APMST.XCOMP, INVMST.XDESC
SQL;FROM INVAPPRICE LEFT JOIN APMST ON INVAPPRICE.ACCID = APMST.ACCID
SQL;LEFT JOIN INVMST ON INVAPPRICE.ID = INVMST.ID
SQL;ORDER BY INVAPPRICE.ID, LINE
CONDITION;ตั้งแต่รหัสสินค้า~INVAPPRICE.ID~Chr~2~SELECT ID FROM INVMST~INV
EXCELSQL;SELECT
EXCELSQL;INVAPPRICE.ACCID, INVAPPRICE.ID, INVAPPRICE.LINE, INVAPPRICE.COST, APMST.XCOMP, INVMST.XDESC
EXCELSQL;FROM INVAPPRICE LEFT JOIN APMST ON INVAPPRICE.ACCID = APMST.ACCID
EXCELSQL;LEFT JOIN INVMST ON INVAPPRICE.ID = INVMST.ID
EXCELSQL;ORDER BY INVAPPRICE.ID, LINE
