SELECT * FROM garantieadherent
WHERE numeroadherent='02260001'


SELECT * FROM garantiebeneficiaire
WHERE numeroBeneficiaire='0226000101'


SELECT * FROM college WHERE id=334



-- 1 Recherche informations de modification le bareme/acte
SELECT * FROM `actesbaremepriseencharge`
WHERE idBaremepriseencharge  IN (335) AND codeGarantie='CON'

-- 1 Recherche informations de modification le bareme/acte
SELECT DISTINCT ticketModerateur FROM `actesbaremepriseencharge`
WHERE idBaremepriseencharge  IN (335)


SELECT * FROM `garantiesbaremepriseencharge`
WHERE idBaremepriseencharge  IN (335)

SELECT * FROM `familleactebaremepriseencharge`
WHERE idBaremepriseencharge  IN (335)


UPDATE `garantiesbaremepriseencharge`  SET tauxPlafond=80 WHERE idBaremepriseencharge  IN (335);

UPDATE `familleactebaremepriseencharge` SET tauxPlafond=80 WHERE idBaremepriseencharge  IN (335);