In our club we wanted to be able to get address and contact phone numbers (home, cell, emergency) into Excel. The Clubber List - Contact Information report does a nice job of providing a printed format, but doesn't import well. On the Clubbers grid I could only find a way to export the primary phone and e-mail.
Therefore, I put together the following SQL to include Cell and Emergency phone numbers in addition to Home phone and E-mail.
SELECT R.Club_Name, P.Person_ID, P.Mailing_Name, P.Filing_Name, H.Parent_Name, H.Address_Line1, H.City, H.State, H.Postal_Code, C1.Contact_Person AS "Emergency_Contact", C1.Display_As AS "Emergency", C2.Display_As AS "Home Phone", C3.Display_As AS "Cell Phone", C4.Display_As AS "E-Mail"
FROM Person P, Administration A
INNER JOIN Role R ON R.Person_ID=P.Person_ID
INNER JOIN Household H ON P.Household_ID=H.Household_ID
LEFT JOIN Communication C1 ON (
(C1.Household_ID=H.Household_ID)
AND (C1.Type='Emergency'))
LEFT JOIN Communication C2 ON (
(C2.Household_ID=H.Household_ID)
AND (C2.Type='Home Phone'))
LEFT JOIN Communication C3 ON (
(C3.Household_ID=H.Household_ID)
AND (C3.Type='Cell Phone'))
LEFT JOIN Communication C4 ON (
(C4.Household_ID=H.Household_ID)
AND (C4.Type='E-Mail'))
WHERE (P.Member_Type='Clubber')
AND (R.Club_Year=A.Current_Club_Year)
AND (P.Status='Active')