Databases: SQL query Help - I need to find teacher's names and email from courses

Databases: SQL query Help - I need to find teacher's names and email from courses

by Miki Alliel -
Number of replies: 0
Picture of Translators
 

I need some help with a SQL query, Selecting teacher's names and email address from all the courses in the system.

I didn't fine a field in the mdl_user table which indicated that the user is in a specific role as teacher.

how can I do it?

Thanks
Average of ratings: -