Members and Studies application

[xionhack]

Hello. I have a question.

 

I am making an application that shows if some "members" have done some "studies". There are 50 set studies. This is the way I have it set up:

 

3 Tables --->

 

Member:

member_id, member_name

 

Studies:

study_id, study_name

 

member_studies:

member_id, study_id, teacher, comments, date

 

In the "member" table I actually have about 50 other fields, I just didnt put them because they were not needed. My concern is, because I have more than 1000 members, If I want to know how many people did for example the "study 1" then, It will do a search through all the ones that have the study_id = 1, then check which name is to the "member_id" and which study_name goes for the "study_id". My problem is that I think that would take a long time. Is it better if I just put those fields for each lesson in the "members" table (the problem with that one, is that I will have more than 200 fields). I dont know If everything is clear, but please let me know if its not, thank you.

[inversesoft123]

Google about "mysql grouping" and "mysql inner join"