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.
If it's not broken, fix it until it is.
My Blog