I am a student. Now is learning the Moodle, I have some questions. 1. In which tables i can get the info that show the teacher's all course. 2. In which tables i can get the info that show one course's student (Ps: the students that select the course) who can tell me. Thanks.
1. Use (join them in this order):
2. It's similar to the above - the tables liked there should give you that information as well.
I am sorry, could you tell me the fields that in each table above. Thanks very much.