SELECT DISTINCT
    R.FIRST_NAME "CONSTIT_FIRSTNAME",
    R.LAST_NAME "CONSTIT_LASTNAME",
    AD.ADDRESS_BLOCK "CONSTIT_ADDRESS",
    SPOUSE.FIRST_NAME "SPOUSE_FIRSTNAME",
    SPOUSE.LAST_NAME "SPOUSE_LASTNAME",
    AD2.ADDRESS_BLOCK "SPOUSE_ADDRESS"
FROM
RECORDS R
    LEFT OUTER JOIN CONSTIT_ADDRESS AS CA ON CA.CONSTIT_ID = R.ID AND CA.PREFERRED = -1
    LEFT OUTER JOIN DBO.ADDRESS AS AD ON AD.ID = CA.ADDRESS_ID
    LEFT OUTER JOIN RECORDS AS SPOUSE ON SPOUSE.ID = R.SPOUSE_ID
    LEFT OUTER JOIN CONSTIT_ADDRESS AS CA2 ON CA2.CONSTIT_ID = SPOUSE.ID AND CA.PREFERRED = -1
    LEFT OUTER JOIN DBO.ADDRESS AS AD2 ON AD2.ID = CA.ADDRESS_ID
WHERE
R.KEY_INDICATOR = 'I'