>Hi everybody,
>
>I can not figure out how to correctly produce the following report:
>
>I have two tables: People (cID, LName, FName) and Phones (cID, Phone, Type).
>
>There are several different types of the phones (Home, Office, Cell, E-Mail and few others).
>
>I want to display the info as
>

>Person Info - group
>
>Home   Office     Cell  E-Mail (Type)

>
>
>So far all the select statements I tried produced wrong results.
>
>May be someone much clever than me can help.
>
>Thanks a lot in advance.

SELECT People.cID,;
       MAX(LName) AS LName,;
       MAX(FName) AS FName,;
       MAX(IIF(Phones.Type=='Home'  , Phone, CAST([] AS C(??))) AS Home,;
       MAX(IIF(Phones.Type=='Office', Phone, CAST([] AS C(??))) AS Office,;
       MAX(IIF(Phones.Type=='Cell'  , Phone, CAST([] AS C(??))) AS Cell,;
....
FROM People;
INNER JOIN Phones ON People.cId == Phones.cId;
GROUP BY People.cID