KaiSaming的博客

1. 等值连接 在条件连接中，运算符为 “ = ” 的一种连接 SELECT * FROM `student` AS S ,`result` AS R WHERE S.StudentNo = R.StudentNo 2. 自然连接 一种特殊的等值连接，可以理解为去重后的等值连接 SELECT S.StudentName AS "姓名" , R.StudentResult AS "成绩" FROM `student` AS S ,`result` AS R WHERE S.StudentNo = R