String sql = "select c.objname objname,c.objdesc objdesc,b.objname m,a.field006 field006,a.field008 field008,a.field009 field009,a.field007 field007,a.id id," +
"datediff(mi,convert(datetime,field007),convert(datetime,field009))/60 alltime,n.field003 field003 " +
"from ufd0i2m81332293713953 a left join project c " +
"on a.field010 = c.id left join humres b " +
"on a.field001 = b.id left join ufx7g8o01332829391541 n " +
"on b.id = n.field001 where c.objname like '%"+all.getProject().getObjname()+"%' " +
"order by b.objname desc";
c.objname objname是什么意思?别名吗,还有,查询结果好多重复的,如何不重复,我加distinct f.id id 说不能对别f.id,就解答哦。
"datediff(mi,convert(datetime,field007),convert(datetime,field009))/60 alltime,n.field003 field003 " +
"from ufd0i2m81332293713953 a left join project c " +
"on a.field010 = c.id left join humres b " +
"on a.field001 = b.id left join ufx7g8o01332829391541 n " +
"on b.id = n.field001 where c.objname like '%"+all.getProject().getObjname()+"%' " +
"order by b.objname desc";
c.objname objname是什么意思?别名吗,还有,查询结果好多重复的,如何不重复,我加distinct f.id id 说不能对别f.id,就解答哦。
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货