You can not select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
baseService/ETL/Doc/项目单位代码的补全.sql

2 lines
139 B

update t_gtzz_subject as t1 join t_base_organization as t2 on t1.xmdw=t2.org_name set t1.xmdw_code=t2.org_code
where t1.xmdw_code is null;