String sql1="select max(a.id) id,a.objname,a.field006,min(a.field006) field006,max(a.field008) field008,"+
"sum(alltime)/60 a,sum(worktime)/60 b,cast(sum(worktime)/sum(alltime) as numeric(16,1)) output,"+
"cast(sum(alltime)/8 as numeric(16,1)) workload "+
"from (select c.objname , b.work,a.id, a.field006,a.field008,field009,"+
"field007,datediff(mi,convert(datetime,field007),convert(datetime,field009)) alltime,"+
"case when b.iswork = '1' then datediff(mi,convert(datetime,field007),"+
"convert(datetime,field009)) else 0 end worktime "+
"from humres c left join [ufh7w7m81332292853750] a "+
"on c.id=a.field001 left join tbiswork b "+
"on a.field004 = b.id "+
"where a.field006>=? and a.field008<=?) a "+
"group by a.objname,a.field006";
String sql = "select row_number() over (order by m.id) as rowNum,f.objname projectname, m.id, m.objname, sum(worktime)/sum(alltime) f,a.field006 from " +
"(select a.field001,a.field006,a.field008,field009,field007,datediff(mi,convert(datetime,field007),"+
"convert(datetime,field009)) alltime,case when b.iswork = '1' then datediff(mi,convert(datetime,field007),"+
"convert(datetime,field009))else 0 end worktime from [ufh7w7m81332292853750] a,tbiswork b "+
"where a.field004 = b.id ) a right join humres m "+
"on m.id = a.field001 left join stationinfo d "+
"on m.mainstation=d.id left join orgunit f "+
"on d.orgid = f.id "+
"where f.objname like '%"+humres.getStationinfo().getOrgunit().getObjname()+"%' "+
"group by m.objname,a.field006,m.id,f.objname";如何合并这两条语句啊?union all ,join,都不行啊,帮忙看看啊。
但注意两个sql字段要对应上,比如字段个数,字段类型