两表拼接

SELECT  sr.NAME, rcs.READTIME, rb.BTSNAME, SUM(rcs.TOTAL_USAGE) totalusage,  TO_CHAR(SUM(rcs.AIRCON_USAGE),'0999.99')  airconusage,
          SUM(rcs.MAIN_USAGE) mainusage,  SUM(rcs.GENERATOR_USAGE) generatorusage
FROM  SYS_REGION sr
full join RES_BTS rb
ON  sr.CODE = rb.CITYID
join  RPT_CAP_BTS rcs    
ON  rcs.BTSID = rb.ZGID
GROUP BY sr.NAME, rcs.READTIME, rb.BTSNAME;


SELECT  sr.NAME, rcm.READTIME, Rm.Machname, SUM(rcm.TOTAL_USAGE) totalusage,  TO_CHAR(SUM(rcm.AIRCON_USAGE),'0999.99')  airconusage,
          SUM(rcm.MAIN_USAGE) mainusage,  SUM(rcm.GENERATOR_USAGE) generatorusage
FROM  SYS_REGION sr
full join RES_MACHROOM rm
ON  sr.CODE = rm.CITYID
join  RPT_CAP_MACHROOM rcm
ON  Rcm.Machroomid = rm.ZGID

GROUP BY sr.NAME, rcm.READTIME, Rm.Machname;

function buildColumns(){
    var columns=[[
        {field:'EC_ITEM_TIME',width:110,title:"时间", halign: 'center', rowspan: 2},
        {field:'EC_ARENA_NAME',width:100,title:"用能场所", halign: 'center', rowspan: 2},
        {field:'EC_CITY_NAME',width:100,title:"城市", halign: 'center', rowspan: 2},
        {title:'总用用电量',halign:'center',colspan:3},
        {title:'主设备用电量',halign:'center',colspan:3},
        {title:'空调用电量',halign:'center',colspan:3},
        {title:'照明和其它用电量',halign:'center',colspan:3}
        ],
        [
            {field:'EC_TOTAL_USAGE', width:110,title:"总用电量(KWH)"},
            {field:'CMR_TOTALCOMSUPTION', width:110,title:"同比(%)"},
            {field:'CMR_TOTALCOMSUPTION', width:110,title:"环比(%)"},

            {field:'EC_ITEM_MAIN_USAGE', width:110,title:"主设备用电(KWH)"},
            {field:'CMR_TOTALCOMSUPTION', width:110,title:"同比(%)"},
            {field:'CMR_TOTALCOMSUPTION', width:110,title:"环比(%)"},

            {field:'EC_AIRCON_USAGE', width:110,title:"空调用电(KWH)"},
            {field:'CMR_TOTALCOMSUPTION', width:110,title:"同比(%)"},
            {field:'CMR_TOTALCOMSUPTION', width:110,title:"环比(%)"},

            {field:'EC_ITEM_GENERATOR_USAGE', width:110,title:"照明和其它(KWH)"},
            {field:'CMR_TOTALCOMSUPTION', width:110,title:"同比(%)"},
            {field:'CMR_TOTALCOMSUPTION', width:110,title:"环比(%)"}
        ]
    ];

    return columns;
}