■ LEFT OUTER JOIN 사용하기

----------------------------------------------------------------------------------------------------

SELECT

    A.StudentID

   ,A.StudentName

   ,A.SchoolID

   ,B.SchoolName

FROM            Student AS A

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

----------------------------------------------------------------------------------------------------

Posted by 사용자 icodebroker
TAG

댓글을 달아 주세요