Mysql-内连接

-- 连接查询
-- inner join ... on
-- select ... from 表A inner join 表B；
select * from student inner join classess;

-- 查询 有能够对应班级的学生以及班级信息
select * from student inner join classess on student.cls_id=classess.id;

-- 按照要求显示姓名、班级
select student.name,classess.name from student inner join classess on student.cls_id=classess.id;

-- 给数据表起名字
select s.name,c.name from student as s inner join classess as c on s.cls_id=c.id;


-- 查询 有能够对应班级的学生以及班级信息，显示学生的所有信息 student.* ， 只显示班级名称 classess.name
select student.*,classess.name from student inner join classess on student.cls_id=classess.id;

-- 在以上的查询中，将班级姓名显示在第1列
select classess.name,student.* from student inner join classess on student.cls_id=classess.id;

-- 查询 有能够对应班级的学生以及班级信息，按照班级进行排序
-- select c.xxx s.xxx from student as s inner join classess as c on ... order by ...；
select classess.name,student.* from student inner join classess on student.cls_id=classess.id ORDER BY classess.name;

-- 当是同一班级的时候，按照学生的id进行从小大到大排序
select classess.name,student.* from student inner join classess on student.cls_id=classess.id ORDER BY classess.name, student.id asc;

 

 

表取自：

Mysql-几张供于学习的表 - 夜黎i - 博客园 (cnblogs.com)