select stu.SId,stu.Sname,a.score from
(SELECT SId,score as "数学" from sc where CId = "02") as a
INNER join student AS stu on stu.SId = a.SId
上面写法是不对的
join里不能as起别名
select stu.SId,stu.Sname,a.score from
(SELECT SId,score as "数学" from sc where CId = "02") as a
INNER join student AS stu on stu.SId = a.SId
上面写法是不对的
join里不能as起别名