PostgreSQL联合查询

多表联合查询

UPDATE contract_contract_file 
SET 
    create_user_name = C.undertake_user_name,
    create_user_account = C.undertake_user_account 
FROM
	contract_contract AS C 
WHERE
	contract_id = C.ID 
AND contract_contract_file.TYPE = 1

单表联合查询

UPDATE contract_contract_file AS newFile 
SET old_file_id = oldFile."id" 
FROM
	contract_contract_file AS