MySql的Join使用

数据

class表:

ID	class_name
1	class 1
2	class 2
3	class 3
4	class 4
5	class 5

students表:

ID	student_name	age	class_id
1	tom	18	1
2	jack	19	1
3	Lucy	18	2
4	Ely	19	3
5	Jon	20	4
6	Messi	19	3
7	Cl	20	3
8	UK	22	6

Join与Inner Join

Join是Inner Join的简写,只有当俩表中都存在的时候才会select

select s.id,s.student_name,s.age,c.class_name,c.id from students s 
join class c on s.class_id=c.id order by s.id;<