subject:"Count even when empty"

Count even when empty

2004-08-15 Thread Bill Easton

Message Follows = From: "John Berman" <[EMAIL PROTECTED]> Subject: Count even when empty Date: Sun, 15 Aug 2004 01:02:52 +0100 Further to my earlier query Im using this SELECT dbo.members_.List_, COUNT(dbo.members_.EmailAddr_) AS nojgid FROM dbo.mem

Count even when empty

2004-08-14 Thread 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_.T