hemm total 3 tabelli
tablenames: mdl_course_categories mdl_role_assignments mdl_context
oqsma: id, userid categoryname, l-id contextid, il instanceid
hekk i bżonn li juri userids bl-ismijiet kategorija tagħhom ................
fil mdl_course_categories id ifisser kategorija id u mdl_context id mezzi contextid
Hello hairsh,
Hawn hu l-mistoqsija tista 'taħdem għal u.
tagħżel mra.userid, mca.categoryname minn mdl_role_assignments MRA, mdl_context mc, mdl_course_category MCC
fejn mra.contextid = mc.id u mc.instanceid = mcc.id