--把以下语句拷到自定义报表程序打开的“数据”菜单下替换原来的语句



select a.xm0000,b.zdmc00,b.jzysxm,b.zdrq00 from sf_brxxb0 a,ys_brzdxx b,xt_icd900 c
where a.ghh000=b.ghh000 and b.zdmc00=c.JBMC00 and c.sfcrb0 =1
and ghrq00 between :开始日期 and :结束日期
union all
select a.xm0000,b.zdmc00,b.jzysxm,b.zdrq00 from sf_brxxb0 a,ys_brzdxx b,bm_zdzd00 c
where a.ghh000=b.ghh000 and b.zdmc00=c.zdmc00 and c.sfcrb0 =1
and ghrq00 between :开始日期 and :结束日期