[DATABASE/SQLITE] INNER JOIN절 사용하기

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

▶ 예제 코드 (SQL)


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

SELECT

A.StudentID

,A.StudentName

,A.SchoolID

,B.SchoolName

FROM Student AS A

INNER JOIN School AS B ON B.SchoolID = A.SchoolID;