mysql 出现ambiguous错误

Question

select ma.`majorName`, count(1) from `student` as stu
inner join `major` as ma 
on ma.`majorId` = stu.`majorId`
group by `majorId`;

出现：
Error Code: 1052. Column 'majorId' in field list is ambiguous
要如何解决，感谢！！

Answer 1

ambiguous表示字段不明确。关联查询的两个表中都有majorId，但group by majorId没有指定用哪个表中的majorId。使用 group by ma.mgajorId 或者 group by stu.majorId