• SET @NAMEID = '14359'

    IF @ADR2 IS NULL AND @ADR3 IS NULL

    SELECT ADR1,

    POSTAL_CODE,

    (STATE_NAME) AS COUNTRY

    FROM PAT_NAMES_ADDRESS AS P

    INNER JOIN STATE_NAME AS S ON P.STATE_ID = S.STATE_ID

    WHERE P.NAME_ID = @nameid

    AND P.CURRENT_ONE = '1'

    AND P.LANGUAGE_ID = '3'

    Have a look at your join on the 2 tables