postgresql连表更新
时间：2021-07-01 10:21:17
帮助过：21人阅读
table_p
as p
set p_name
= a.name,p_user
= a.
user_id,p_type
= ‘P02‘
from (
select x.
user_id,x.name,x.p_id
from table_u x
join table_p y
on x.p_id
= y.p_id
) as a
where p.p_id
= a.p_id;
postgresql连表更新
标签：pre ble type tab nbsp join bsp 连表 postgres
