SELECT T.ID ,
T.ADDRESS ,
T.CITY ,
T.POSTAL_CODE ,
T.STATE
FROM dbo.LOCATION T
WHERE EXISTS ( SELECT 1
FROM LOCATION
WHERE ID = T.ID
AND ADDRESS <> T.ADDRESS );