SELECT * FROM p_feuillemaladie WHERE numeroFeuilleMaladie=10914


UPDATE p_feuillemaladie SET montantArembourser=10400,fraisRetenu=10400,montantTm=2600 WHERE Iid=26800


SELECT * FROM p_feuillemaladie WHERE numeroFeuilleMaladie=10914


-- 	SELECT SUM(A.montantApayer) INTO @consommationBeneficiaire 


SELECT * FROM college WHERE idPolice=185


SELECT * FROM beneficiaire WHERE idPolice=209 AND idCollege=358   numeroBeneficiaire='0209000301'


SELECT * FROM adherent WHERE idPolice=209 AND idCollege=358    


UPDATE  beneficiaire SET plafond=1000000,ticketModerateur=20 WHERE idPolice=209 AND idCollege=358 

UPDATE  adherent SET plafondAdherent=1000000,ticketModerateurAdherent=20 WHERE idPolice=209 AND idCollege=358 

UPDATE  limiteadherent SET plafondAdherent=1000000,plafondAnnuel=1000000 WHERE idPolice=209 

UPDATE  limitebeneficiaire SET plafondBeneficiaire=1000000,plafondAnnuel=1000000 WHERE idPolice=209 

SELECT * FROM limitebeneficiaire WHERE idPolice=209




SELECT * FROM college WHERE id=209




SELECT * FROM police WHERE libellePolice LIKE '%EGC%'