MySQL Correlation Query Inner connection

Internal connection [inner| Cross] JOIN
Unconditional Internal connection:
Unconditional internal connection, aka Cross connect/Cartesian connection
Each item in the first table will be combined with each of the other tables in turn
#例:
Mysql> SELECT * FROM student inner JOIN department;
Conditional Intra-connection:
On the basis of an unconditional inner join, add an ON clause
When connecting, filter out rows of meaningful records for stitching
#例:
Mysql> SELECT * FROM student INNER JOIN department
-On Dept_id=id;

Examples of internal connections:
#需求: Find out the name of the student and the name of the school
Mysql> Select S.s_name name, D.d_name College from student s
-INNER JOIN Department D
-On dept_id= d_id;

MySQL Correlation Query Inner connection