1
2
3
4
5
6
7
8
9
10
11
12
| SELECT USERS.nom, STATUTS.LIBELLE,COUNT(*) AS QT
FROM USERS, SAVENTETE,SAVENTETEMATPAN, STATUTS, DIVISION,ARTICLES,HISTSTATUT
WHERE HISTSTATUT.id_statut = STATUTS.id_statut
AND HISTSTATUT.ID_SIGLNUM = SAVENTETEMATPAN.ID_SIGLNUM
AND SAVENTETEMATPAN.ID_USER = USERS.ID_USER
AND SAVENTETEMATPAN.ID_DIVISION = DIVISION.ID_DIVISION
AND SAVENTETEMATPAN.ID_ARTICLE = ARTICLES.ID_ARTICLE
AND HISTSTATUT.DATE_MODIF BETWEEN TO_DATE('23/04/2008','dd/mm/yyyy') AND TO_DATE('24/04/2008','dd/mm/yyyy')
AND HISTSTATUT.id_statut = 76
group by USERS.nom,STATUTS.libelle
order by USERS.nom |
