读书人

SQl UPDATE 多表关联有关问题

发布时间: 2012-09-03 09:48:39 作者: rapoo

SQl UPDATE 多表关联问题

UPDATE ta SET Name='alovejun' FROM T_User AS ta INNER JOIN T_AreaSet AS  tb ON tb.AreaId=ta.AreaIdWHERE 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

?

读书人网 >PowerDesigner

热点推荐