C# 多表联查去掉重复列

Question

select Student.*,Course.*,Score.* from Score

inner join Student on Student.SId=Score.SId

inner join Course on Course.CId=Score.CId

这是代码，查出三张表全部内容（需要这么做，我知道表.字段），如何把重复的SID,CID 这两列去掉。

Answer 1

select Student.*,Course.*,Score.* from Score
inner join Student on Student.SId=Score.SId
inner join Course on Course.CId=Score.CId
group by Score.SId,Score.CId