mysql> select s.,c. from t_student s join t_class c on s.classno=c.cno;
±----±---------±--------±----±---------------+
| sno | sname | classno | cno | cname |
±----±---------±--------±----±---------------+
| 1 | lucy | 100 | 100 | Grade3 class1 |
| 3 | king | 200 | 200 | Grade3 class 2 |
| 4 | Hanmeime | 200 | 200 | Grade3 class 2 |
| 5 | wangwu | 300 | 300 | Grade3 class 3 |
| 6 | lijun | 300 | 300 | Grade3 class 3 |
±----±---------±--------±----±---------------+
5 rows in set (0.00 sec)
mysql> select * from t_student;
±----±---------±--------+
| sno | sname | classno |
±----±---------±--------+
| 1 | lucy | 100 |
| 3 | king | 200 |
| 4 | Hanmeime | 200 |
| 5 | wangwu | 300 |
| 6 | lijun | 300 |
±----±---------±--------+
5 rows in set (0.00 sec)
mysql> select * from t_class;
±----±---------------+
| cno | cname |
±----±---------------+
| 200 | Grade3 class 2 |
| 300 | Grade3 class 3 |
| 100 | Grade3 class1 |
±----±---------------+
3 rows in set (0.00 sec)