SELECT

DISTINCT C.CLAIMANT_NUMBER

FROM CLAIM C

INNER JOIN CLIENT C ON C.CLAIMANT_NUMBER=C.CLIENT_NUMBER
INNER JOIN ADDRESS A2 ON C.CLAIMANT_NUMBER = A2.CLIENT_NUMBER
' ' OR A2.ADDRESS1 IS NOT NULL)
AND A2.SEQUENCE_NUMBER = (SELECT MAX (SEQUENCE_NUMBER) FROM ADDRESS A4 WHERE A2.CLIENT_NUMBER = A4.CLIENT_NUMBER)
A3.POLICY_NUMBER AND P.POLICY_DATE_TIME = A3.POLICY_DATE_TIME
WHERE (SELECT DISTINCT C.CLAIMANT_NUMBER FROM CLAIM C)

SELECT C.CLAIMANT_NUMBER,
       C.CLAIMANT_NAME
FROM   CLAIM C
       INNER JOIN CLIENT C
            ON  C.CLAIMANT_NUMBER = C.CLIENT_NUMBER
       INNER JOIN ADDRESS A2
            ON  (
                    C.CLAIMANT_NUMBER = A2.CLIENT_NUMBER
                    OR A2.ADDRESS1 IS NOT NULL
                )
            AND A2.SEQUENCE_NUMBER = (
                    SELECT MAX(SEQUENCE_NUMBER)
                    FROM   ADDRESS A4
                    WHERE  A2.CLIENT_NUMBER = A4.CLIENT_NUMBER
                )
            AND A3.POLICY_NUMBER = 'SOMETHING HERE'
            AND P.POLICY_DATE_TIME = A3.POLICY_DATE_TIME
--NOT SURE WHAT THIS WHERE CLAUSE IS FOR
--WHERE  (
--           SELECT DISTINCT C.CLAIMANT_NUMBER
--           FROM   CLAIM C
--       )

SELECT DISTINCT C.CLAIMANT_NUMBER,
       C.CLAIMANT_NAME
FROM   CLAIM C
       INNER JOIN CLIENT C
            ON  C.CLAIMANT_NUMBER = C.CLIENT_NUMBER
       INNER JOIN ADDRESS A2
            ON  (
                    C.CLAIMANT_NUMBER = A2.CLIENT_NUMBER
                    OR A2.ADDRESS1 IS NOT NULL
                )
            AND A2.SEQUENCE_NUMBER = (
                    SELECT MAX(SEQUENCE_NUMBER)
                    FROM   ADDRESS A4
                    WHERE  A2.CLIENT_NUMBER = A4.CLIENT_NUMBER
                )
            AND A3.POLICY_NUMBER = 'SOMETHING HERE'
            AND P.POLICY_DATE_TIME = A3.POLICY_DATE_TIME