--界面显示SQL
select T.* from vw_bq_ypyzzxd_qxcf T where yflbid in (3) and (qyrq00 = zxrq00)

--打印主SQL
select bqh000,zyid00,(select bmmc00 from bm_bmbm00 where bmbh00 = bqh000) bqmc00,t.yzid00,T.YZMXID,
xm0000,zyh000,ch0000,Ypmc00,ypgg00,LYL000,ZYFYDW,ypyfmc,csrq01,zxrq01,zxrq00,YZNR01,HDRXM0，
MCSLDW from vw_bq_ypyzzxd_qxcf T  where yflbid in (3) and (qyrq00 = zxrq00)

--明细SQL
select T.*,'' as zxsj00,(select count(1) from bq_yzcfmx where t.yzid00=yzid00 and t.zxrq00=zxrq00)*T.mcsl00 zsl000,
(select ZQCYTS from bq_ypyz00 where yzid00 = T.yzid00) ZQCYTS from vw_bq_ypyzzxd_qxcf T 
where yflbid in (3) and (qyrq00 = zxrq00)

--打印主SQL分组字段
bqh000,zyid00,xm0000,zyh000,ch0000,ypmc00,ypgg00,lyl000,zyfydw,zxrq01,zxrq00,ypyfmc,csrq01,
yzid00,YZNR01,HDRXM0,MCSLDW，yzmxid