UPDATE t1 SET t2_id = t2.id, t3_id = t2.t3_id
FROM t2
WHERE t2.loan_id = t1.loan_id
转载于:https://my.oschina.net/yukong/blog/1574162
UPDATE t1 SET t2_id = t2.id, t3_id = t2.t3_id
FROM t2
WHERE t2.loan_id = t1.loan_id
转载于:https://my.oschina.net/yukong/blog/1574162