Count problem

**todd2006** · todd2006, March 13th, 2010 03:04 PM

Hi,

I have 2 tables

codes
StudentMembers

In codes the table design is like this

Code:

Id
PromoCode
Price

In StudentMembers the table design is like this

Code:

Id
Name
Code
Price
DateSigned

What I want to do is display ow many students used what code so my query is like this

Code:

Select Count(Code), PromoCode from Codes, StudentMembers where Codes.PromoCode=StudentMembers.Code

the query is not working

any idea

todd

**richyrich** · richyrich, March 13th, 2010 03:11 PM

What do you mean by it's not working? Does it give any errors?

I would have thought something like this should work:-

Code:

Select Count(A.Id) AS NumberofStudents, A.PromoCode from StudentMembers A GROUP BY A.PromoCode

Thread: Count problem