public int insertOldSbsj() { String sql = "select c.CODE,c.name,a.start_date,a.end_date,a.NORMAL_CNT,a.BACK_CNT,a.DEPOSE_CNT,b.machine_no,(a.NORMAL_CNT+a.BACK_CNT+a.DEPOSE_CNT) as totalSum,a.normal_sum,a.back_sum,(select count(SN) as num from SERVER_DECLARE_MAKE WHERE substring(DATETIME,0,9)>=a.start_date AND substring(DATETIME,0,9)<=a.end_date AND MACHINE_NO IN(SELECT MACHINE_NO FROM SERVER_TAXPAYER_FISCAL WHERE USER_SN IN(SELECT SN FROM SERVER_TAXPAYER_USER WHERE CODE=c.CODE))) AS YSBSUM FROM SERVER_DECLARE a left join SERVER_TAXPAYER_FISCAL b on a.FISCAL_CARD_NO=b.FISCAL_CARD_NO left outer join SERVER_TAXPAYER_USER c on b.USER_SN = c.SN WHERE a.START_DATE>='20110101' AND a.END_DATE<='20110228' group by c.CODE,a.start_date,a.end_date,c.name,a.NORMAL_CNT,a.BACK_CNT,a.DEPOSE_CNT,a.normal_sum,a.back_sum,b.machine_no"; int result = Query.executeSql(sql); if (result == -1) { result = 1; } else result = -1; return result; }