Operand should contain 1 column(S);

来源:互联网 发布:微软云计算平台包含 编辑:程序博客网 时间:2024/06/04 19:02

select t.Tname,c.Cname,a.Avg(Score) from Teacher t left join Course c on t.T = c.T left join SC a on c.C = a.C group by (Tname,Cname)

出现Operand should contain 1 column(S);

解决办法删除点group by 后面的一项结果就显示出来了

select t.Tname,c.Cname,a.Avg(Score) from Teacher t left join Course c on t.T = c.T left join SC a on c.C = a.C group by (Tname)

阅读全文
0 0
原创粉丝点击