Hi All
i am compiling a mysql query to show the names of the editing teachers in each course but im looking at the database and can't work out the relationship between tables.
ie link up editing teachers to each course?
Please i will happily have an attempt at writing my own sql just want some direct what i need to link up
Thank you
Gary
You need the look at the roles tables.
Also, take a look at some of the queries over in the Ad-hoc queries which deal with roles and enrollments. There are several, such as https://docs.moodle.org/32/en/ad-hoc_contributed_reports#LIST_of_all_site_USERS_by_COURSE_enrollment_.28Moodle_2.x.29
Have a look at this database schema by Marcus Green - http://www.examulator.com/er/