[SQL] JOIN 종류 및 예시

1. Left Join SELECT (etc) FROM TableA A LEFT JOIN TableB B ON A.Key = B.Key SELECT (etc) FROM TableA A LEFT JOIN TableB B ON A.Key = B.Key WHERE B.Key IS NULL 2. Right Join SELECT (etc) FROM TableA A RIGHT JOIN TableB B ON A.Key = B.Key SELECT (etc) FROM TableA A LEFT JOIN TableB B ON A.Key = B.Key WHERE B.Key IS NULL 3. Inner Join SELECT (etc) FROM TableA A INNER JOIN TableB B ON A.Key = B.Key ..

2023.07.27