PostgreSQL 连表UPDATE 实例 绝地灬酷狼 2022-11-28 13:19 87阅读 0赞 [https://blog.csdn.net/londa/article/details/108060431][https_blog.csdn.net_londa_article_details_108060431] 根据上文写出的具体实例: UPDATE wr_device_bts wr_bts SET bbu_id = temp_tbl.bbucuid FROM ( SELECT bbulog.wr_cuid bbucuid, btslog.wr_cuid btscuid FROM v_irms_mt_wireless_bts vibts, v_device_wireless_bts vbts, v_irms_mt_wireless_bbu bbu, wr_yr_sync_log btslog, wr_yr_sync_log bbulog where bbulog.yr_res_type_key = 'bbu' and bbulog.yr_cuid = bbu.CUID and bbu.bbu名称 = vbts.所属BBU and vbts.综合资源网元ID = vibts.CUID and vibts.CUID = btslog.yr_cuid and btslog.yr_res_type_key = 'bts' ) temp_tbl where wr_bts.site_id = temp_tbl.btscuid; [https_blog.csdn.net_londa_article_details_108060431]: https://blog.csdn.net/londa/article/details/108060431
还没有评论,来说两句吧...