SQL Join on the second table

[yosiasz]

search in this forum

select (datediff(month,'1914-07-28',getdate())+1)/12 as age

Age and member month computation

Is this what you're looking for? select memid ,fullname ,dob ,sex ,enrollid ,enrolleffdate ,enrolltermdate ,(datediff(month,dob,enrolleffdate)+1)/12 as age ,case when (datediff(month,dob,enrolleffdate)+1)/12<21 then 0 else datediff(month,enrolleffdate,enrolltermdate) end as membermonth from @memage ;