SQl UPDATE多表关联问题

Sql代码 
UPDATE ta SET Name='alovejun' FROM T_User AS ta 
 INNER JOIN T_AreaSet AS  tb ON tb.AreaId=ta.AreaId 
WHERE tb.AreaId LIKE '%4312%' 
 
实例： 
UPDATE tb SET tb.CurrentAge=((tb.CurrentYear*12+tb.CurrentMonth)-(Year(ta.Birthday)*12+MONTH(ta.Birthday)))/12 FROM T_Person AS ta  
INNER JOIN T_ChangeCases AS tb ON ta.PersonId=tb.PersonId 

作者“IT技术交流”