[DATABASE/SQLITE] LEFT OUTER JOIN절 사용하기

■ LEFT OUTER JOIN절을 사용하는 방법을 보여준다.

▶ 예제 코드 (SQL)


SELECT
    A.StudentID
   ,A.StudentName
   ,A.SchoolID
   ,B.SchoolName
FROM            Student AS A
LEFT OUTER JOIN School  AS B ON B.SchoolID = A.SchoolID;

SELECT

A.StudentID

,A.StudentName

,A.SchoolID

,B.SchoolName

FROM Student AS A

LEFT OUTER JOIN School AS B ON B.SchoolID = A.SchoolID;