62,051
社区成员
发帖
与我相关
我的任务
分享
CREATE TABLE tb_a(id int identity(1,1) primary key,coulmn1 nvarchar(50), coulmn2 nvarchar(50), coulmn3 nvarchar(50))
CREATE TABLE tb_b(id int identity(1,1) primary key,coulmn1 nvarchar(50), coulmn2 nvarchar(50), coulmn3 nvarchar(50))
INSERT tb_a
SELECT 'B','C','f'UNION ALL
SELECT 'B','e','D'UNION ALL
SELECT 'B','C','D'UNION ALL
SELECT 'B','e','D'UNION ALL
SELECT 'B','q','D'
INSERT tb_b
SELECT 'B','C','g'UNION ALL
SELECT 'B','e','g'UNION ALL
SELECT 'B','C','g'UNION ALL
SELECT 'B','e','g'UNION ALL
SELECT 'B','C','g'
UPDATE tb_a SET tb_a.coulmn3=tb_b.coulmn3 from tb_a INNER JOIN tb_b ON tb_a.coulmn1 = tb_b.coulmn1 AND tb_a.coulmn2=tb_b.coulmn2
SELECT * FROM tb_a
SELECT * FROM tb_b
CREATE TABLE tb_a(id int identity(1,1) primary key,coulmn1 nvarchar(50), coulmn2 nvarchar(50), coulmn3 nvarchar(50))
CREATE TABLE tb_b(id int identity(1,1) primary key,coulmn1 nvarchar(50), coulmn2 nvarchar(50), coulmn3 nvarchar(50))
INSERT tb_a
SELECT 'B','C','f'UNION ALL
SELECT 'B','e','D'UNION ALL
SELECT 'B','C','D'UNION ALL
SELECT 'B','e','D'UNION ALL
SELECT 'B','q','D'
INSERT tb_b
SELECT 'B','C','g'UNION ALL
SELECT 'B','e','g'UNION ALL
SELECT 'B','C','g'UNION ALL
SELECT 'B','e','g'UNION ALL
SELECT 'B','C','g'
UPDATE tb_a SET tb_a.coulmn3=tb_b.coulmn3 from tb_a INNER JOIN tb_b ON tb_a.coulmn1 = tb_b.coulmn1 AND tb_a.coulmn2=tb_b.coulmn2
SELECT * FROM tb_a
SELECT * FROM tb_b