SELECT
    A.S01_END_ELETRONICO AS NM_EMAIL_ANALISTA,
    B.S01_END_ELETRONICO AS NM_EMAIL_GESTOR
FROM PER_006
JOIN SYS_001 A ON
	P06_NR_CONTRATO_CAMBIO = A.S01_CD_LOGIN_USUARIO
LEFT JOIN SYS_001 B ON
	A.S01_CD_DEPTO_TRABALHO = B.S01_CD_LOGIN_USUARIO
WHERE
    P06_NR_EMBARQUE = ''