SELECT
    dbo.EA7FACULTY.USERDEFINEDID,
    dbo.EA7FACULTYATTRIBUTES.ATTRIBUTETYPESID,
    dbo.EA7FACULTYATTRIBUTES.TEXT
    FROM
           dbo.EA7FACULTYATTRIBUTES RIGHT OUTER JOIN
           dbo.EA7FACULTY ON dbo.EA7FACULTYATTRIBUTES.PARENTID = dbo.EA7FACULTY.EA7FACULTYID
    WHERE
    (dbo.EA7FACULTYATTRIBUTES.ATTRIBUTETYPESID IN (47, 48, 49, 50, 51, 52) AND (dbo.EA7FACULTY.STATUS = 1611))

===================================================================================
USERDEINEDID    ATTRIBUTETYPESID    TEXT
771100      51          123 123 1234
771100      49          234 567 8910
771100      47          me@me.com
771100      48          me2@me.com


USERDEINEDID    47      48      49      50  51
771100      me@me.com   me2@me.com  234 567 8910    NULL    123 123 1234