哪位sql大神进来帮帮忙

"select dnno,jgdj,fh,hwzl,name,name2,sum(zmyzj) as zmyzj,sum(jzmj) as jzmj,sum(symj) as symj,sum(jz) as jz,name1,sum(zmyzj1) as zmyzj1,sum(jzmj1) as jzmj1,sum(symj1) as symj1,sum(jz1) jz1,ydyycmx from(";
  cmd += "select dnno,jgdj,fh,hwzl,name,'暂免交租' as name2,xzj as zmyzj,jzmj as jzmj,symj as symj,jz as jz,'暂免交租' as name1,0 as zmyzj1,0 as jzmj1,0 as symj1,0 as jz1,'月租金减免调整' as ydyycmx from hhwzl where officecode in (" + code + ") and shenhe='审核通过' and rrny='" + bdate + "' and zmyzj2<>'0' ";

这是asp.net里面提取出来的
谁能告诉我这个查询语句是什么意思？

这字段命名的太疼了！

是不是在 asp.net 这样定义的,
var cmd= "select dnno,jgdj,fh,hwzl,name,name2,sum(zmyzj) as zmyzj,sum(jzmj) as jzmj,sum(symj) as symj,sum(jz) as jz,name1,sum(zmyzj1) as zmyzj1,sum(jzmj1) as jzmj1,sum(symj1) as symj1,sum(jz1) jz1,ydyycmx from(";
cmd += "select dnno,jgdj,fh,hwzl,name,'暂免交租' as name2,xzj as zmyzj,jzmj as jzmj,symj as symj,jz as jz,'暂免交租' as name1,0 as zmyzj1,0 as jzmj1,0 as symj1,0 as jz1,'月租金减免调整' as ydyycmx from hhwzl where officecode in (" + code + ") and shenhe='审核通过' and rrny='" + bdate + "' and zmyzj2<>'0' ";
这是个嵌套查询,意思是说:
先从 hhwzl 中 查询出 officecode 在 code 中的,code 的形式 应该为 code[,code[,code[...]]],
并且shenhe='审核通过', rrny为bdate 推断为时间 如'2011-09-30',zmyzj2 不为 '0' 的记录
然后再从上面查询的记录中 按dnno,jgdj,fh,hwzl,name,name2 分组计数

应该还少了点sql语句, 下回发到sql版基础版