两表链接更新

有朋友问到，两个表如何链接更新，这里举例说明：

CREATE TABLE data1(
name NVARCHAR(8) NOT NULL,
sex CHAR(1) NOT NULL,
age INT default 0)
GO

CREATE TABLE data2(
name NVARCHAR(8) NOT NULL,
age INT NOT NULL CHECK(age>0))
GO

INSERT INTO data1(name,sex) VALUES
('王五','1'),
('张三','1'),
('李四','1')
GO

INSERT INTO data2 VALUES
('王五',23),
('张三',24),
('李四',28)
GO

/*更新data1的年龄为data2的相应年龄*/

UPDATE data1 SET age=(SELECT age FROM data2 WHERE name=data1.name)