数据库批量查找插入

[清晨宸]

如下，已有表A,需要根据A填充表B中的c列，怎么填？

CREATE TABLE [dbo].[TA](
	[id] [int] IDENTITY(1,1) NOT NULL PRIMARY KEY,
	[b] [varchar](50) NULL,
	[c] [varchar](50) NULL)


CREATE TABLE [dbo].[TB](
	[id] [int] IDENTITY(1,1) NOT NULL PRIMARY KEY,
	[b] [varchar](50) NULL,
	[c] [varchar](50) NULL)

表A

表B


用游标？还是用什么、欢迎指教

[向东流]

update b set b.c=a.c from a,b where a.id=b.id and a.b=b.b

[chen357313771]

UPDATE B
SET B.C=A.C
FROM [tableA] AS A
JOIN [tableB] AS B ON A.B=B.B