SQL
-
SQL 테스트 준비CS/Database 2022. 1. 2. 21:59
JOIN INNER JOIN SELECT A.NAME FROM A INNER JOIN B ON A.ID = B.ID; LEFT OUTER JOIN SELECT A.NAME FROM A LEFT OUTER JOIN B ON A.ID = B.ID; LEFT JOIN EXCLUDING INNER JOIN SELECT A.NAME FROM A LEFT OUTER JOIN B ON A.ID = B.ID WHERE B.ID IS NULL; RIGHT OUTER JOIN SELECT A.NAME FROM A RIGHT OUTER JOIN B ON A.ID = B.ID; RIGHT JOIN EXCLUDING INNER JOIN SELECT A.NAME FROM A RIGHT OUTER JOIN B ON A.ID = B..