留言板
- 进击の少女
- 问个问题：string sql = "select Jname,Jnumber,t1.sum1,t2.sum2,t3.sum3,t4.sum4,t5.sum5,(isnull(t1.sum1,'')+isnull(t2.sum2,'')+isnull(t3.sum3,'')+isnull(t4.sum4,'')+isnull (t5.sum5,'')) as sum6 from " +
"(select Jname,Jnumber,SUM(Incomeamount) sum1 from Ssfreetofees where Timeh>=" + "'" + ls_startdate12 + "'" + "and " + "Timeh<=" + "'" + Is_enddate22 + "' ) as t1 " +
"left join( select Jname,Jnumber,SUM(Incomeamount) sum2 from Ssctoni where Timeh>=" + "'" + ls_startdate12 + "'" + "and " + "Timeh<=" + "'" + Is_enddate22 + "' ) as t2 on t1.Jnumber= t2.Jnumber" +
"left join(select Jname,Jnumber,SUM(Incomeamount)sum3 from Msfreetochangefees where Timeh>=" + "'" + ls_startdate12 + "'" + "and " + "Timeh<=" + "'" + ls_enddate22 + "' ) as t3 on t1.Jnumber = t3.Jnumber " +
"left join (select Jname,Jnumber,SUM(Incomeamount) sum4 from MsNC where Timeh>=" + "'" + ls_startdate12 + "'" + "and " + "Timeh<=" + "'" + Is_enddate22 + "' group by sum4) as t4 on t1.Jnumber = t4.Jnumber " +
"left join (select Jname,Jnumber,SUM(Incomeamount) sum5 from MsStoL where Timeh>=" + "'" + ls_startdate12 + "'" + "and " + "Timeh<=" + "'" + Is_enddate22 + "' ) as t5 on t1.Jnumber = t5.Jnumber " +
"where t1.Jnumber <> ''";
这哪里出错了？
