SELECT
    R.USERDEFINEDID "Record ID",
    R.FIRSTNAME "First name",
    R.LASTNAME "Last name",
    M.OBJECT "Media type",
    M.DESCRIPTION "Media description"

FROM
DBO.EA7FACULTY F
    INNER JOIN EA7RECORDS R ON R.EA7RECORDSID = F.EA7RECORDSID
    LEFT OUTER JOIN EA7FACULTYMEDIA M ON M.PARENTID = F.EA7FACULTYID