SELECT
  a.id  AS id,
  -- a.codeSociete AS codeSociete,
  -- a.codeGarantie AS codeGarantie,b.libelle  AS garantie,
  a.codeFamilleActe AS codeFamilleActe,d.libelle  AS familleActe,
  a.codeActe  AS codeActe,a.libelle AS acte,
  a.lettreCle AS lettreCle,a.coefficient AS coefficient,
 --  a.codeTarifActe AS codeTarifActe,
  (CASE WHEN (a.lettreCle <> '') THEN CONCAT(a.libelle,' [',a.lettreCle,a.coefficient,'] ') ELSE a.libelle END) AS libelle,
  a.codeTypePrestation AS codeTypePrestation,e.libelle AS typePrestation,
  -- a.prix  AS prix,
  a.ententePrealable  AS ententePrealable,
 -- a.alerte AS alerte,
  a.exclu  AS exclu,
  a.maladieChroniqueActe AS maladieChroniqueActe,
  a.chirurgie AS chirurgie,
  a.delaiCarenceActe AS delaiCarenceActe,
  a.actif AS actif
  -- ,  a.miseEnObservation AS miseEnObservation
FROM (((p_acte a JOIN garantie b ON (b.codeGarantie = a.codeGarantie))
JOIN p_familleacte d ON (d.codeFamilleActe = a.codeFamilleActe))
JOIN p_typeprestation e ON (e.codeTypePrestation = a.codeTypePrestation)) 