现在有两张表,因为前期设计的缺陷 需要加些改变 现在需要以下的需求:表一:
goods_id pr_id admin_id
1 1 0
2 1 0
3 2 0
4 3 0表2:
pr_id admin_id
1 1
2 2
3 3类似这样
现在需要把表一数据中admin_id给同步了
goods_id pr_id admin_id
1 1 1
2 1 1
3 2 2
4 3 3请问这个sql 该如何写?在线等!
goods_id pr_id admin_id
1 1 0
2 1 0
3 2 0
4 3 0表2:
pr_id admin_id
1 1
2 2
3 3类似这样
现在需要把表一数据中admin_id给同步了
goods_id pr_id admin_id
1 1 1
2 1 1
3 2 2
4 3 3请问这个sql 该如何写?在线等!
from 表一 a left join 表2 b on a.pr_id=b.pr_id
UPDATE 表一 SET 表一.admin_id = B.admin_id
from 表2 AS B WHERE on 表一.pr_id = B.pr_id
from 表2 AS B WHERE 表一.pr_id = B.pr_id
UPDATE a
SET a.admin_id=b.admin_id
FROM 表1 a INNER JOIN 表2 b ON a.pr_id=b.pr_id
from 表2 AS B WHERE on 表一.pr_id = B.pr_id
FROM dbo.Table_2
WHERE dbo.Table_1.id = dbo.Table_2.id