strSql = "SELECT "
strSql = strSql & " DECODE( T1.TOUKEI1, 0, T1.TOKUICD, '00' || T1.TOUKEI1) As TOKUICD ,"
strSql = strSql & " SUM(T2.ZYUNURI) As URI ,"
strSql = strSql & " SUM(T2.ARARI) As ARI"
strSql = strSql & " FROM "
strSql = strSql & " TMA0BA T1 ,"
strSql = strSql & " TMA4BA T2 "
strSql = strSql & " WHERE "
strSql = strSql & " T2.TOKUICD = T1.TOKUICD "
strSql = strSql & " AND "
strSql = strSql & " T2.YM <= '" & TdateYMFrom & "'"
strSql = strSql & " AND T2.YM <= '" & TdateYMTo & "'"
strSql = strSql & " GROUP BY "
strSql = strSql & " DECODE( T1.TOUKEI1, 0, T1.TOKUICD, '00' || T1.TOUKEI1)"
to_date(T2.YM,'YYYY-MM-DD')<= to_date('" & TdateYMFrom & "','YYYY-MM-DD')
to_date(T2.YM,'YYYY-MM-DD')<= to_date('" & TdateYMTo & "','YYYY-MM-DD')
strSql = strSql & " DECODE( T1.TOUKEI1, 0, T1.TOKUICD, '00' || T1.TOUKEI1) As TOKUICD ,"
strSql = strSql & " SUM(T2.ZYUNURI) As URI ,"
strSql = strSql & " SUM(T2.ARARI) As ARI"
strSql = strSql & " FROM "
strSql = strSql & " TMA0BA T1 ,"
strSql = strSql & " TMA4BA T2 "
strSql = strSql & " WHERE "
strSql = strSql & " T2.TOKUICD = T1.TOKUICD "
strSql = strSql & " AND "
strSql = strSql & " T2.YM >= '" & TdateYMFrom & "'"
strSql = strSql & " AND T2.YM <= '" & TdateYMTo & "'"
strSql = strSql & " GROUP BY "
strSql = strSql & " DECODE( T1.TOUKEI1, 0, T1.TOKUICD, '00' || T1.TOUKEI1)"
TdateYMFrom <= T2.YM <= TdateYMTo