POCHEMY NE RABOTAET?//????

UPDATE UMB_PERSON_ADDRESS
SET Expired = 1
FROM UMB_PERSON_ADDRESS
JOIN
( SELECT Person_id
FROM UMB_PERSON_ADDRESS
WHERE IS_MAILING_ADDRESS = 1
AND EXPIRED = 0
GROUP BY (PERSON_ID)
HAVING COUNT(*) > 1
) AS A ON UMB_PERSON_ADDRESS.PERSON_ID = A.PERSON_ID
JOIN
( SELECT PERS_ADDRESS_ID = MIN (PERS_ADDRESS_ID)
FROM UMB_PERSON_ADDRESS
WHERE IS_MAILING_ADDRESS = 1
AND EXPIRED = 0
) AS B ON UMB_PERSON_ADDRESS.PERS_ADDRESS_ID = B.PERS_ADDRESS_ID

POCHEMY NE RABOTAET?//????

spasiba poprobuem