请一句sql查询

[无恶不作的黑猫警长]

用一句sql，查出学生名字及所有科目名和科目成绩，没有相应成绩的，用'-'显示

[带我飞的云]

SELECT t.name, s.`subject`, IFNULL(s.score,'-')
FROM student AS t
INNER JOIN score AS s ON s.uid = t.id

[无恶不作的黑猫警长]

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