UPDATE时的问题

create table t1(id int null,data int null)

create table t2(id int null,data int null)

insert into t1 values(1,2)
insert into t2 values(1,3)

update t1 set t1.data=data
where t1.id in (select t2.id from t2)

 为什么这样就不行呢？

update t1 set t1.data=t2.data
where t1.id in (select t2.id from t2)