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.