内连
SELECT * FROM student as s INNER JOIN sc as sc on s.sno=sc.sno
多表内连
SELECT * FROM student as s
INNER JOIN sc on s.sno=sc.sno
INNER JOIN course as c on c.courseid=sc.courseid
左外连 (student全部显示)
SELECT * FROM student as s
LEFT JOIN sc ON s.sno=sc.sno
右外连 (sc全部显示)
SELECT * FROM student as s
RIGHT JOIN sc ON s.sno=sc.sno