sqltable="select t1.id,yhbh,isnull(pz,0) as pz,isnull(dq,'暂无') as dq,isnull(zl,'暂无') as zl from lwmx t1,lw t2 where t1.zbid=t2.id and t1.lx='01' and substring(CONVERT(varchar(100), t2.fbrq, 23),1,4)='"&nd&"' and t2.lwzt='1' order by yhbh"sqltable="select t1.id,yhbh,isnull(pz,0) as pz,