[阅读: 492] 2006-10-10 06:03:15
select XX_DY.*, YH_YH.Lxdh, AQ_CZY.sj
from XX_DY, YH_YH, ZC_ZDZC, AQ_CZY
where YH_YH.hh = XX_DY.hh
and YH_YH.dwdm = XX_DY.Dwdm
and ZC_ZDZC.Yhid = YH_YH.Yhid
and XX_DY.KHFZRDY = '1'
and AQ_CZY.sj = '130'
and XX_DY.Dyfs in ('00','02')
and YH_YH.Khjlid = AQ_CZY.CZYID
union all
select XX_DY.*, YH_YH.Lxdh, AQ_CZY.sj
from XX_DY, YH_YH, ZC_ZDZC, AQ_CZY
where YH_YH.hh = XX_DY.hh
and YH_YH.dwdm = XX_DY.Dwdm
and ZC_ZDZC.Yhid = YH_YH.Yhid
and XX_DY.KHFZRDY = '1'
and AQ_CZY.sj = '130'
and XX_DY.Dyfs in ('00','02')
and ZC_ZDZC.Zrrid = AQ_CZY.CZYID