Hi...

The query below returns the number of times that each subject has been used, but if the subject has been used zero times it does not return it.


Can please anyone tell me how can i change it in order to return zero as well...

select offer_details.subject, count(offer.offerdate) AS "Number Of Times"
from offer, offer_details
where offer.offerDate > '1/jan/00'
AND offer.offercode = offer_details.offercode
group by offer_details.subject;

Thanks on advance...