Hello -
I have this query :

SELECT
B.CODE_PROD ,
SUM(B.QTE_RECUE_ENT)

FROM
RECEPTION_MARCHANDISE_MAITRE A,
RECEPTION_MARCHANDISE B

where
A.NO_RECEPTION=B.NO_RECEPTION_MAITRE
AND DATE_RECUE='2004-12-17'
AND A.VALIDER='O'
AND A.NO_SUCC=3
GROUP BY B.CODE_PROD

-----------
From this, i want only B.CODE_PROD showing ACTIF='Y' from table
PRODUIT C to show. (Note: CODE_PROD are identical in both PRODUIT and
RECEPTION_MARCHANDISE tables). I have found no way to add this filter
to the existing script. Any one have an idea? Thank. RP.