SQL server 联查更新

SQL联查更新

update t_caliper_report_param set t_caliper_report_param.dep_id = t_dep_project.dep_id from t_caliper_report_param,t_dep_project 
where t_caliper_report_param.project_id = t_dep_project.project_id

  

posted @ 2023-01-29 14:35  も不秃不秃  阅读(54)  评论(0编辑  收藏  举报