UPDATE "schema_name1"."table_name1" AS t1
SET field_name1 = t2.field_name2
FROM "schema_name2"."table_name2" AS t2
WHERE t1.keyid = t2.keyid
当表2中包含多条记录满足 t1.keyid = t2.keyid
时,取第一条记录作为最终的匹配结果。
UPDATE "schema_name1"."table_name1" AS t1
SET field_name1 = t2.field_name2
FROM "schema_name2"."table_name2" AS t2
WHERE t1.keyid = t2.keyid
当表2中包含多条记录满足 t1.keyid = t2.keyid
时,取第一条记录作为最终的匹配结果。