requête 1 pour compter l'le nombre de prélèvement par service

[quote:3rfnuqpv]select
count(distinct p.prelevement_id) as Prlvt,
SERVICE.NOM

from
PRELEVEMENT p, ECHANTILLON e, ECHANTILLON_TYPE, SERVICE, ETABLISSEMENT

where
SERVICE.ETABLISSEMENT_ID = ETABLISSEMENT.ETABLISSEMENT_ID
and
SERVICE.SERVICE_ID = p.SERVICE_PRELEVEUR_ID
and
p.PRELEVEMENT_ID = e.PRELEVEMENT_ID
and
e.ECHANTILLON_TYPE_ID = ECHANTILLON_TYPE.ECHANTILLON_TYPE_ID
and
ECHANTILLON_TYPE.TYPE like 'tissu%'
and
e.EMPLACEMENT_ID is not null
and
date_format(e.date_stock,'%Y') in ('2014')
and
date_format(e.date_stock,'%m') in ('07','08','09','10','11','12')
and
ETABLISSEMENT.NOM like 'CHU J%'

group by
SERVICE.NOM

order by
count(distinct p.prelevement_id) desc[/quote:3rfnuqpv]

requête 2 pour compter le nb de prélèvement avec délais d'acheminement trop long

[quote:3rfnuqpv]select
SERVICE.NOM,
count(distinct PRELEVEMENT.PRELEVEMENT_ID) as nb_prlv

from 
PRELEVEMENT left join ECHANTILLON on ECHANTILLON.PRELEVEMENT_ID = PRELEVEMENT.PRELEVEMENT_ID, ECHANTILLON_TYPE, SERVICE, ETABLISSEMENT

where
ECHANTILLON.ECHANTILLON_TYPE_ID = ECHANTILLON_TYPE.ECHANTILLON_TYPE_ID
and
SERVICE.ETABLISSEMENT_ID = ETABLISSEMENT.ETABLISSEMENT_ID
and
SERVICE.SERVICE_ID = PRELEVEMENT.SERVICE_PRELEVEUR_ID
and
ECHANTILLON_TYPE.TYPE like 'TI%'
and
left(PRELEVEMENT.CODE,3) = '001'
and 
date_format(ECHANTILLON.date_stock,'%Y') = '2014'
and
date_format(ECHANTILLON.date_stock,'%m') in ('01','02','03','04','05','06')
and
date_format(PRELEVEMENT.DATE_ARRIVEE,'%T') not in ('00:00:00')
and
date_format(PRELEVEMENT.DATE_PRELEVEMENT, '%T') not in ('00:00:00')
and
timestampdiff (minute, PRELEVEMENT.DATE_PRELEVEMENT, PRELEVEMENT.DATE_ARRIVEE) &gt;= '30'

Group by
SERVICE.NOM[/quote:3rfnuqpv]


Et au final je voudrais regrouper les 2  <!-- s:bave: --><img src="{SMILIES_PATH}/nico54.gif" alt=":bave:" title="" /><!-- s:bave: -->