oracle更新表数据的方法
2020-04-24 17:21 菜码地里的小白 阅读(442) 评论(0) 编辑 收藏 举报merge into JNGHCG.SSG_GCHX_PY gc using (SELECT T.PROJECTCODE AS PROJECTCODE,R.YDXZ AS YDXZ FROM BZ_PROJECTCASE T LEFT JOIN BZ_GC_HXSJ R ON R.CID = T.ID) B on(b.projectcode = gc.xmid) when matched then update set gc.ydxz = b.ydxz where gc.objectid = 10644
