UPDATE A SET A.REGISTRO = B.REGISTRO
--SELECT A.REGISTRO, B.REGISTRO, A.PERIODO, B.PERIODO,  A.SEGMENTO_FINAL, B.SEGMENTO_FINAL
FROM ODS.HM_SEG_BPE A
INNER JOIN (
	SELECT *
	FROM ODS.HM_SEG_BPE_VERSION_OLD
	WHERE PERIODO = (SELECT MAX(PERIODO) FROM ODS.HM_SEG_BPE_VERSION_OLD)
) B
ON A.CODUNICOCLI = B.CODUNICOCLI
WHERE A.PERIODO = (SELECT MAX(PERIODO) FROM ODS.HM_SEG_BPE)

Add a code snippet to your website: www.paste.org