SELECT * FROM beneficiaire  -- where idAvenant=346
WHERE numeroBeneficiaire IN ('0082028701','0082001401')

SELECT * FROM adherent WHERE id=633



UPDATE beneficiaire
SET dateSortie=NULL ,codeMotifSortie='',dateEffet='2022-01-01',enVigueur=1,primeArchive=0,sorti=0,ratioAvenant=0.9783   
WHERE numeroBeneficiaire IN ('0082028701')

UPDATE adherent
SET  dateSortie=NULL ,codeMotifSortie='',dateEffet='2022-01-01',sorti=0
WHERE id=633

