SELECT 
id,idAdherent,numeroBeneficiaire,numeroAdherent,`dateSortie`,`codeMotifSortie`,dateEntree,dateEffet,enVigueur,sorti,codeEtatBeneficiaire
FROM `beneficiaire`
WHERE numeroAdherent="01270062";
-- WHERE numeroAdherent="00760015";

SELECT id,numeroAdherent,`dateSortie`,`codeMotifSortie`,dateEntree,dateEffet,enVigueur,sorti
FROM `adherent`
WHERE numeroAdherent="01270068";
-- WHERE numeroAdherent="00760015";


SELECT * FROM `etatadherent` WHERE idPolice=205

-- idAdherent=1395

SELECT * FROM `etatbeneficiaire` WHERE idBeneficiaire IN (3843,4052,4204) AND `user`="lionel"

SELECT * FROM police WHERE libellePolice LIKE 'mer%'


-- mise a jour des benefidciaire charlesEric

UPDATE beneficiaire b
JOIN adherent a ON (a.id=b.idAdherent)
SET b.dateSortie=(NULL),b.codeMotifSortie='',b.sorti=0,b.codeEtatBeneficiaire="V",
a.dateSortie=(NULL),a.codeMotifSortie='',a.sorti=0,a.codeEtatAdherent="V"	
WHERE b.numeroAdherent IN ("01270064","01270062","01270065","01270077","01270070",
"01270064","01270060","01270069","01270137","01270055");






UPDATE beneficiaire
SET dateSortie=(NULL),codeMotifSortie='',sorti=0
WHERE numeroAdherent="01270068";

UPDATE `etatbeneficiaire` 
SET codeEtatBeneficiaire="R"
WHERE idBeneficiaire IN (3843,4052,4204) AND `user`="lionel";

UPDATE adherent
SET dateSortie=(NULL),codeMotifSortie='',sorti=0 
WHERE `numeroAdherent`="01270068";

UPDATE `etatadherent` 
SET codeEtatAdherent="R" 
WHERE idAdherent IN (1395) AND `user`="lionel";





