>Hi Naomi, relax your brain ...
>try:
>

>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.

What would you get if you have, say, 2 home phones and 1 cell and no e-mail, for example?