>SELECT People.cID,; > People.LName,; > People.FName,; > Home.Phone AS Home,; > Office.Phone AS Office,; > Cell.Phone AS Cell,; >.... >FROM People; >LEFT JOIN Phones Home ON People.cId == Home.cId AND Home.Type =='Home'; >LEFT JOIN Phones Office ON People.cId == Home.cId AND Office.Type =='Office'; >LEFT JOIN Phones Cell ON People.cId == Home.cId AND Cell.Type =='Cell' ; >.... >I believe I tried this variation too and it didn't work as I wanted it to.