多表连接查询-内连接-外连接

内连接：

1 在WHERE子句中指定连接条件

SELECT  STUDENT.Sname,STUDENT.Sid,SCORE.Score

FROM STUDENT,SCORE

WHERE STUDENT.StudentID=SCORE.ScoreID

2 在FROM子句中使用INNER JOIN...ON

  SELECT S.SNAME,S.SADDRESS,C.SCORSE

FROM STUDENT AS S INNER JOIN SCORSE AS C ON (S.SID= C.SID)

外连接

左外连接：

在FROM语句中加入 LEFT (OUTER) JOIN...ON

SELECT S.SName,C.CourseID,C.Score

FROM STUDENT AS S LEFE JOIN SCORE AS C ON (S.SCODE = C.STUDENTID)

右外连接和左外连接原理相同