To use an SQL, find out the student name and all the course name and course grades, there is no corresponding results, use '-' shows

CodePudding user response:

The SELECT t.n ame, s. ` subject `, IFNULL (s.s core, '-')
The FROM student AS t
INNER JOIN score AS s ON s.u id=t.i d

CodePudding user response:

SELECT student name, IFNULL (score. The subject, '-') as a subject, IFNULL (score. The score, '-') as the score FROM the student LEFT the JOIN score ON score. The uid=student. Id;