SELECT
DBO.ADDRESSLINE(1,T_1.ADDRESS_BLOCK) "Preferred Address Line 1",
DBO.ADDRESSLINE(2,T_1.ADDRESS_BLOCK) "Preferred Address Line 2",
DBO.ADDRESSLINE(3,T_1.ADDRESS_BLOCK) "Preferred Address Line 3",
RECORDS.ID "QRECID"

FROM
DBO.RECORDS AS RECORDS INNER JOIN DBO.CAPREFERRED AS RECORDS_CAPreferred ON RECORDS.ID = RECORDS_CAPreferred.CONSTIT_ID INNER JOIN DBO.ADDRESS AS T_1 ON RECORDS_CAPreferred.ADDRESS_ID = T_1.ID

WHERE
((RECORDS.IS_CONSTITUENT = -1))