SELECT
R.FIRSTNAME,
R.LASTNAME,
T_4.DESCRIPTION "Contact type",
T_3.NUM "Contact number",
T_2.ALLOWTOSHARE

FROM
EA7RECORDS R
LEFT OUTER JOIN DBO.ADDRESSLINKS_EA7RECORDS AS T_1 ON R.EA7RECORDSID = T_1.PARENTRECORDID
LEFT OUTER JOIN DBO.PHONELINKS AS T_2 ON T_1.ADDRESSLINKSID = T_2.ADDRESSLINKSID
LEFT OUTER JOIN DBO.ADDRESSLINKPHONES AS T_3 ON T_2.PHONESID = T_3.PHONESID
LEFT OUTER JOIN DBO.TABLEENTRIES AS T_4 ON T_3.PHONETYPE = T_4.TABLEENTRIESID

ORDER BY
R.LASTNAME