with b as (
SELECT * from table
)
UPDATE a SET(xxx,xxx,xxx)=
(
SELECT xxx,xxx,xxx FROM b WHERE a.id = b.id
) WHERE EXISTS(SELECT 1 FROM b WHERE a.id = b.id)
sql将一张表的字段更新到另外一张表
最新推荐文章于 2023-12-08 16:27:34 发布
with b as (
SELECT * from table
)
UPDATE a SET(xxx,xxx,xxx)=
(
SELECT xxx,xxx,xxx FROM b WHERE a.id = b.id
) WHERE EXISTS(SELECT 1 FROM b WHERE a.id = b.id)