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