update fc.fc_header
set so_name=temp.name
from fc.customer temp
where 1=1 and
fc_header.key=temp.key
and fc_header.so_customer=temp.customer
postgresql根据a表跟新b表,固定写法,set后用别名就会报错
最新推荐文章于 2023-06-07 23:33:07 发布
update fc.fc_header
set so_name=temp.name
from fc.customer temp
where 1=1 and
fc_header.key=temp.key
and fc_header.so_customer=temp.customer