alasql( "SELECT cust.[会社名], cust.[顧客ランク], SUM(orders.[受注金額]) as [受注金額] \ FROM ? AS cust JOIN ? AS orders ON cust.[会社名] = orders.[顧客名] \ GROUP BY cust.[会社名], cust.[顧客ランク] \ ORDER BY cust.[会社名]", [obj.rs1, obj.rs2]); //////////////////////////////////////////////////////////////////////////// // kintone JavaScript: Summary of kintone records by alasql. // 2017.02.14 by rex0220 //////////////////////