有一表内有人员资料包含出生日期，另一表有人员包含变动日期字段，如何在第三表中计算出人员变动时的岁数？
谢谢。
[解决办法]
select t1.uid,t2.cdate-t1.bdate as uage
from t1,t2
where t1.uid=t2.uid
[解决办法]
select
t1.Date as CS
,t2.Date as BD
,DATEDIFF([year], t1.date, GETDATE())-(t2.Date-t1.Date) AS age
* from t1
left join t2 on t1.name = t2.name
大概就是这样吧
