>>SELECT RecordId, FirstName, LastName FROM Contacts WHERE LastName = 'marois' >>RecordId FirstName LastName >>------------------------------------------------------- >>4010 Kevin Marois >> >> >> >>SELECT * FROM Phones WHERE ContactId = 4010 >>RecordId ContactId PhoneTypeId PhoneNum >>----------- ----------- ----------- -------------------------------------------------- >>58920 4010 4 +19513920229 >>58921 4010 1 +19512233208 >> >>SELECT * FROM PickLists WHERE ItemType = 'phone' >>RecordId Caption ItemType >>----------- ------------------------------ -------------------- >>1 Home phone >>2 Office phone >>3 FAX phone >>4 Cell phone >>5 Other1 phone >>6 Other2 phone >>7 Other3 phone >> >>SELECT ContactId, [1] AS [Home], [2] AS Office, [3] AS Fax, [4] AS Cell, [5] AS [Other1], [6] AS [Other2], [7] AS [Other3] >> FROM Phones >> PIVOT (MIN(PhoneNum) FOR PhoneTypeID IN ([1], [2], [3], [4], [5], [6], [7])) TempList >> WHERE ContactId = 4010 >> >>ContactId Home Office Fax Cell Other1 Other2 Other3 >>----------- --------------- ---------- ---------- --------------- ---------- ---------- ---------- >>4010 NULL NULL NULL +19513620229 NULL NULL NULL >>4010 +19512433208 NULL NULL NULL NULL NULL NULL >>>>