Select COUNT(HISTORIQUEBUG.IDBUG) as Nombre, USER.IDUSER, USER.NOM
From HISTORIQUEBUG, USER
WHERE HISTORIQUEBUG.IDUSER = USER.IDUSER
AND (HISTORIQUEBUG.IDETATBUG = '2SANS' OR HISTORIQUEBUG.IDETATBUG = '3DEV')
AND HISTORIQUEBUG.DATE>='04/04/2005'
-- AND HISTORIQUEBUG.DATE<'05/04/2005'
Group by USER.IDUSER, USER.NOM
Order by Nombre DESC --USER.NOMABREGE
---------------
"I wonder if the internal negative pressure in self pumping toothpaste tubes is adjusted for different market altitudes." John Carmack