从主从表中查询对应的外键，需要指定外键的表，即sno=》 student.sno或者score.sno
错误：select sno,sname,degree from student,score where student.sno=score.sno;
正确：select student.sno,sname,degree from student,score where student.sno=score.sno;
mysql在查询中常见问题汇总
标签：name pos font blog div gpo str 常见 img