postgresql 多表关联update delete

pg多表关联update

两表关联更新示例

UPDATE t_user_bank b
SET is_active='是'
FROM t_user_arch u 
WHERE  u.arch_id=b.arch_id 
and u.rec_no='2021090306002'

多表关联更新时

UPDATE t_user_bank b
SET is_active='是'
FROM t_user_arch u INNER JOIN t_deposit d ON u.arch_id=d.arch_id
WHERE  u.arch_id=b.arch_id and d.balance=0 
and u.rec_no='2021090306002'

delete删除指定表数据

DELETE FROM t_tableA tc
using t_tableB tp 
WHERE tc.part_no=tp.part_no and cdata_interval='1'