update mswss_contract_documents as a
set areaid = b.areaid
from (
select * from mswss_project_info
) as b where a.xmqlcid = b.id;
pgsql多表联合批量更新
最新推荐文章于 2024-07-15 06:44:37 发布
update mswss_contract_documents as a
set areaid = b.areaid
from (
select * from mswss_project_info
) as b where a.xmqlcid = b.id;