Select b.fID,b.stuclass,b.stuname,c.type,
CASE c.subject WHEN '语文' THEN c.score ELSE 0 END '语文',
CASE c.subject WHEN '数学' THEN c.score ELSE 0 END '数学',
CASE c.subject WHEN '英语' THEN c.score ELSE 0 END '英语'
From nczx_stucj_stuinfo b
Left Join nczx_stucj_info c On b.stuname = c.stuname
为什么我查询成绩都会0 呢、明明都是有成绩的,没有空的?秋指点!!