7-10.sql

来自「SQL2000跟课件学习的源代码 分享共同学习」· SQL 代码 · 共 10 行

左外连接：
SELECT S.SpecialityID, S.SpecialityName, SC.CourseID, SC.Term
FROM Speciality_Course SC 
  LEFT OUTER JOIN Speciality S ON S.SpecialityID = SC.SpecialityID

右外连接：
SELECT S.SpecialityID, S.SpecialityName, SC.CourseID, SC.Term
FROM Speciality_Course SC 
  RIGHT OUTER JOIN Speciality S ON S.SpecialityID = SC.SpecialityID