Microsoft 365 Left join sans doublons

" from DB_EVENEMENT ev1 left join DB_SUPPORT sup on ev1.IS_SUPPORT=sup.IS_SUPPORT" & _
    " left join ( select distinct TX_BONUS_BRUT_DEF_CTRAT from  DB_TAUX_PAB_CTRAT) bonus on ev1.IS_SUPPORT=bonus.IS_SUPPORT and bonus.N_ANNEE=(extract(YEAR from CURRENT_DATE)-1)" & _
    " left join DB_EVENEMENT ev2 on ev1.NO_POLICE=ev2.NO_POLICE and ev1.IS_SUPPORT=ev2.IS_SUPPORT and" & _