REPORTFORM;AR3.frf
TITLE;Customer Information Report 
SQL;SELECT ARMST.ACCID,ARMST.XCOMP, ARMST.TEL, ARMST.FAX, ARMST. XNAME,ARMST. ADD_1, ARMST.ADD_2,
SQL;ARMST.ROUTE, ARMST.SHIPTO_1, ARMST.SHIPTO_2, ROUTE.AREA1,ARMST.AREA, AREA.ADESC
SQL;FROM ARMST  
SQL;LEFT JOIN  ROUTE ON ARMST.ROUTE = ROUTE.ROUTE
SQL;LEFT JOIN AREA ON ARMST.AREA = AREA.AID
SQL;ORDER BY ARMST.ACCID, ARMST.XCOMP, ARMST.ROUTE
CONDITION;ตั้งแต่รหัสลูกค้า~ARMST.ACCID ~Chr~2~SELECT ACCID FROM ARMST ~AR
EXCELSQL;SELECT ARMST.ACCID AS "รหัสลูกค้า" ,ARMST.XCOMP AS "ชื่อบริษัท", ARMST.TEL AS "โทร", ARMST.FAX AS "แฟ็กซ์", 
EXCELSQL;ARMST. XNAME AS "ชื่อผู้ติดต่อ",ARMST. ADD_1 AS "ที่อยู่ 1", ARMST.ADD_2 AS "ที่อยู่ 2",
EXCELSQL; ARMST.SHIPTO_1 AS "สถานที่ส่งของ 1", ARMST.SHIPTO_2 AS "สถานที่ส่งของ 2", ARMST.ROUTE AS "สายส่ง", ROUTE.AREA1 AS "รายละเอียด", ARMST.AREA AS "เขตการขาย",
EXCELSQL;AREA.ADESC AS "รายละเอียดเขตการขาย" FROM ARMST  
EXCELSQL;LEFT JOIN  ROUTE ON ARMST.ROUTE = ROUTE.ROUTE
EXCELSQL;LEFT JOIN AREA ON ARMST.AREA = AREA.AID
EXCELSQL;ORDER BY ARMST.ACCID, ARMST.XCOMP, ARMST.ROUTE
