yzm742603(提问者)这是我写的服务器数据集,如何修改?
select * from VI_ZW_FYDZ_KM left join VIEW_YT_CBMXB_01 on VI_ZW_FYDZ_KM.F_FYID=VIEW_YT_CBMXB_01.F_FYID
where VI_ZW_FYDZ_KM. F_YWLBMC=\'成本预提\'
and F_YRQ>=TO_DATE(\'2022-01-01\',\'YYYY-MM-DD\') AND F_YRQ<=sysdate
and VIEW_YT_CBMXB_01.F_FYMC <> \'passenger service charge(代收代付)\'
AND VIEW_YT_CBMXB_01.F_FYMC <> \'security screening for passenger and baggage(代收代付)\'
and VIEW_YT_CBMXB_01.F_FYMC <> \'International Tourist Tax(代收代付)\'
and F_PZFL is not null
and F_YCDPZJE=0