/*select floor(months_between(hire_date,dob)/12) age from employee;*/
SELECT u.operator_dob, l.acddate, floor(months_between(to_date(l.acddate+2000000,'yyyyddd'), to_date(u.operator_dob+1900000,'yyyyddd'))/12) age
FROM ACCESS_2009_LOCATION l LEFT JOIN ACCESS_2009_UNITS u
ON l.ACDNUMBER = u.ACDNUMBER
WHERE u.OPERATOR_DOB >0 AND l.TotalInjury >0; 
