select * from 多张表的用法

其实就是 inner join

select * from  Class c,Student s where c.ClassID=s.ClassID

select * from Class c inner join  Student s on  c.ClassID=s.ClassID

效果是一样的

原文地址:https://www.cnblogs.com/xushining/p/3727347.html