如下,已有表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
------解决方案--------------------
UPDATE B
SET B.C=A.C
FROM [tableA] AS A
JOIN [tableB] AS B ON A.B=B.B