Column ‘id’ in field list is ambiguous
select student.id, student.name, score.total
from student, score
where student.id = score.id
使用别名的例子：
用表名进行区分的例子：
select s.id, s.name, c.total
from student s, score c
where s.id = c.id
版权声明：本文为weixin_52165531原创文章，遵循CC 4.0 BY-SA版权协议，转载请附上原文出处链接和本声明。