July 7th, 2010 
harishkumar 
there are total 3 tables
tablenames: mdl_course_categories mdl_role_assignments mdl_context
fields: id , categoryname userid , contextid id , instanceid
so i need to display userids with their category names…………….
in mdl_course_categories id means category id and mdl_context id means contextid
Posted in 
Hello hairsh,
Here is the query can works for u.
select mra.userid,mca.categoryname from mdl_role_assignments mra,mdl_context mc,mdl_course_category mcc
where mra.contextid=mc.id and mc.instanceid=mcc.id