Discuss "count problem" in the SQL Development forum.

todd2006 · #1 September 7th, 2008, 12:24 PM

Hi,
I have this query i am trying to find out how many students registered having a student no.

If the student has a student no he will enter it in the status field

if he doesnt has a student no the field will be blank

I have this query but the count it gives me is not right

can someone tell me whats wrong with it

Code:

   strdist="SELECT DISTINCT Registration.Country, COUNT(Registration.Country) AS [count]FROM Registration INNER JOIN Registration_Tracking ON Registration.Email = Registration_Tracking.Email WHERE  Registration_Tracking.Status Is Not Null  and (Registration_Tracking.Type = 'Arts')GROUP BY Registration.Country order by Country"

todd