you can try something like this:
Select (det.emp_id,det.emp_name,det.emp_last_name,
(select phone_no from table emp_address where epmid =det.emp_id and type = 'cell') as 'cell',(select phone_no from table emp_address where epmid =det.emp_id and type = 'Res') as 'Res')
from table emp_detail det
I am currently not having SQL to check the query but the logic could be like this.
[EDIT] Used "pre" tag for the code