[quote=&quot;aimecie&quot;:2lza4bby]Yahoo j'ai trouvé  <!-- s:content: --><img src="{SMILIES_PATH}/content.gif" alt=":content:" title="" /><!-- s:content: --> 

faux renvoyer l'identifiant au lieu de 1 et utiliser count distinct à la place de sum  <!-- s:geek: --><img src="{SMILIES_PATH}/geek.gif" alt=":geek:" title="" /><!-- s:geek: --> 

[code:2lza4bby]SELECT
   service,
   count(distinct CASE WHEN macondition de recherche1 THEN blabla_id ELSE null END) AS nb_blabla,
   count(distinctCASE WHEN macondition de recherche2  THEN blibli_id ELSE null END) AS nb_blibli
FROM matable
   et mes jointures
WHERE
   condition de recherche commune
GROUP BY service
ORDER BY  cequetuveux[/code:2lza4bby]

Encore merci  <!-- s:pape: --><img src="{SMILIES_PATH}/pape.gif" alt=":pape:" title=":pape:" /><!-- s:pape: -->[/quote:2lza4bby]

Perfect MC  <!-- s:pape: --><img src="{SMILIES_PATH}/pape.gif" alt=":pape:" title=":pape:" /><!-- s:pape: -->