I have a students table Student(LRN,fName,lName,levelID) and a grade table GRADE(subjectID,grade,levelID,LRN,TimeAdded) I want to show all students with all of thier subjects with grades in on line. I tired this query but I got this results.
Query: SELECT student.LRN, student.fName, student.lName,
(SELECT grade.grade WHERE grade.subjectID = 'k2arts') AS 'k2arts',
(SELECT grade.grade WHERE grade.subjectID = 'k2math') AS 'k2math',
(SELECT grade.grade WHERE grade.subjectID = 'k2eng') AS 'k2eng',
(SELECT grade.grade WHERE grade.subjectID = 'k2valed') AS 'k2valed',
(SELECT grade.grade WHERE grade.subjectID = 'k2fil') AS 'k2fil'
from student RIGHT JOIN grade on grade.LRN=student.LRN
Results: Query Result