select * from 多张表的用法

select * from 多张表的用法

 

其实就是 inner join

1.  
   select * from Class c,Student s where c.ClassID=s.ClassID
2.  
    
3.  
   select * from Class c inner join Student s on c.ClassID=s.ClassID

效果是一样的