I want to generate a report with a category, subcategory, and course. The query which I have used is:
Select cc.id, cc.name , cc.parent,c.fullname
FROM prefix_course AS c
INNER JOIN prefix_course_categories AS cc ON c.category=cc.id
I want the parent category name in the Category field, but it's giving the Parent Category ID.
Please help me with this.