Moodle SQL Report

I got this SQL code from Moodle SQL scripts How to make the result to include all itemnames whether it has a score or not? prefix_grade_grade table contains the score prefix_grade_items table has the itemnames Not sure what vendor, these scripts are used in Moodle LMS open source system SELECT [login to view URL] AS 'Name' , [login to view URL] AS 'Surname', [login to view URL] AS 'Course', [login to view URL] AS 'Category', CASE WHEN [login to view URL] = 'Course' THEN [login to view URL] + ' Course Total' ELSE [login to view URL] END AS 'Item Name', ROUND([login to view URL] / [login to view URL] * 100 ,2) AS Percentage FROM prefix_course AS c JOIN prefix_context AS ctx ON [login to view URL] = [login to view URL] JOIN prefix_role_assignments AS ra ON [login to view URL] = [login to view URL] JOIN prefix_user AS u ON [login to view URL] = [login to view URL] JOIN prefix_grade_grades AS gg ON [login to view URL] = [login to view URL] JOIN prefix_grade_items AS gi ON [login to view URL] = [login to view URL] JOIN prefix_course_categories AS cc ON [login to view URL] = [login to view URL] WHERE [login to view URL] = [login to view URL] AND [login to view URL] != 'Attendance' AND [login to view URL] != 'scorm' ORDER BY `Name` ASC