select p.id, p.fname, p.lname, h.phonenumber, o.phonenumber
from Person p
inner join
Contacts h
on p.id = h.id
and h.phonetype = 'HOME'
inner join
Contacts o
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.
HTH
=================================================
We are far more concerned about the desecration of the flag than we are about the desecration of our land. -Wendell Berry
How to get desired result using simple sql query
Posted - 11/01/2012 : 12:41:26
