UPDATE waterqualmonitdata_copy1
SET sectionid= a.id
from waterqualmonitsection a, waterqualmonitdata_copy1 b
WHERE b.section_name=a.name and a.province=b.province
postgresql update语句关联多个表
最新推荐文章于 2024-01-31 13:40:00 发布
![](https://img-home.csdnimg.cn/images/20240711042549.png)
UPDATE waterqualmonitdata_copy1
SET sectionid= a.id
from waterqualmonitsection a, waterqualmonitdata_copy1 b
WHERE b.section_name=a.name and a.province=b.province