select nvl(rpt_report_month_wgdlid , 0) rpt_report_month_wgdlid,MM_JYWG_VALUE,MM_JEWG_VALUE,MM_GDWG_VALUE,MM_RTWG_VALUE,MM_TZLWGDL_VALUE from
dual l
left join (
select
rpt_report_month_wgdlid
,MM_JYWG_VALUE,MM_JEWG_VALUE,MM_GDWG_VALUE,MM_RTWG_VALUE,MM_TZLWGDL_VALUE
from rpt_report_month_wgdl
where to_char(data_time,'yyyy-mm')='2018-01'
) on 1 = 1
oracle 解决表中没有数据,需要id进行更新问题
最新推荐文章于 2021-04-14 23:06:31 发布