select p.id, p.fname, p.lname, h.phonenumber, o.phonenumber
from Person p
on p.id = h.id
and h.phonetype = 'HOME'
on p.id = o.id
and o.phonetype = 'OFFICE'You may want to use outer joins to support the case where a Person does not have both types of phones. Also, a PIVOT might be a better approach, but I rarely use it so can't really speak to that.
We are far more concerned about the desecration of the flag than we are about the desecration of our land. -Wendell Berry