[MSSQL] JOIN정리 LEFT JOIN, INNER JOIN, RIGHT JOIN 정리

--LEFT JOIUN SELECT * FROM TABLE A LEFT JOIN TABLE B ON A.ID = B.ID WHERE B.KEY IS NULL --;EFT JOIN SELECT * FROM, TABLE A LEFT JOIN TABLE B ON A.ID = B.ID --INNER JOIN SELECT * FROM TABLE A INNER JOIN TABLE B ON A. KEY = B.KEY --RIGHT JOIN SELECT * FROM TABLE A RIGHT JOIN TABLE B ON A.KEY = B.KEY WHERE A.KEY IS NULL --RIGHT JOIN SELECT * FROM TABLE A RIGHT JOIN TABLE B ON A.KEY = B.KEY --FULL O..