Hi All,
How can i do my sql query for getting competency ratting with user and module detail, currently i can able to getting competency ratting with course and user detail for using below query
select cc.id, cc.userid, cc.courseid, cc.competencyid, cc.grade,
cc.usermodified,
cc.timemodified as ctimemodified
from mdl_competency_usercompcourse cc
But i need to relation between module and competency ratting, could you please suggest some query and let me know