Count even when empty

[John Berman]

Further to my earlier query

 

 

Im using this

 

SELECT     dbo.members_.List_, COUNT(dbo.members_.EmailAddr_) AS nojgid

FROM         dbo.members_ INNER JOIN

                      dbo.lists_ ON dbo.members_.List_ = dbo.lists_.Name_
INNER JOIN

                      dbo.topics_ ON dbo.lists_.Topic_ = dbo.topics_.Title_

WHERE     (dbo.members_.jgid IS NULL)

GROUP BY dbo.members_.List_

 

 

This works but I want to get a 0 when dbo.members_.jgid IS NULL so my output
shows a 0 for a list, currently is does not show the list when its empty
(obviously because I use is null)

 

 

Pointers appreciated

 

 

Regards

 

John Berman

[EMAIL PROTECTED]