select region from table1 where employeeid in (select 
employeeid from table2 where age in (select max(age) from 
table2))

select t1.id, t2.region from  table t1 left outer Join table2 t2
on t1.id=t2.id 
where t1.id in (select id from table1 where age=(select
max(age) from table1))

Hi  Shivaraj 
the ans you have given that is correct but 
anyway,
if different employee id have same age and different region
and region is null in that case will not show Null region
for that employee


it may be solution....

select t1.id, t2.region from t1 left outer Join t2
on t1.id=t2.id 
where t1.id in (select id from t1 where age=(select max(age)
from t1)) group by  t1.id, t2.region

SELECT REGION,AGE, T1.EMPID FROM T2 INNER JOIN T1
ON T1.EMPID = T2.EMPID WHERE AGE = (SELECT MAX(AGE) FROM T1)

SELECT REGION FROM T2 T2 INNER JOIN
T1 T1 ON T1.EMPID = T2.EMPID INNER JOIN
(SELECT MAX(AGE) AGE FROM T1) TBLAGE ON T1.AGE = TBLAGE.AGE

select ID, region from tab1 where ID in
(select ID from tab2 where isnull(age,0)=(select max(age)
from tab2))

select e.empid,e2.region from empAge1 e,empAge2 e2
where e.empid=e2.empid and e.age in(select max(age) from 
empAge1)