Re: FN-FORUM: SQL / programming Q

date posted 3rd October 2006 20:09

On 3 Oct 2006 18:39:22 -0000, Dai Williams [EMAIL REMOVED] wrote:
>
> If it is NULL and assuming a sensible database then something like
>
> SELECT g.GroupID,g.GroupName,count(r.ClientID) AS
> NumTotal,count(r.SubmittedDate) AS NumComplete FROM tblGroups as g INNER
> JOIN tblResults as r ON g.GroupID = r.GroupID GROUP BY g.GroupID,g.GroupName
> ORDER BY g.GroupName

Thanks Dai. I'm getting this error:

----------------8