![[MySQL] JOIN 연산의 종류](https://img1.daumcdn.net/thumb/R750x0/?scode=mtistory2&fname=https%3A%2F%2Fblog.kakaocdn.net%2Fdna%2FcZImNv%2FbtsIdxUA6o7%2FAAAAAAAAAAAAAAAAAAAAANRqT9kBSdgDGwrBjtj_0ws1rUoSBVaV0ti7tDvnW_WG%2Fimg.png%3Fcredential%3DyqXZFxpELC7KVnFOS48ylbz2pIh7yKj8%26expires%3D1756652399%26allow_ip%3D%26allow_referer%3D%26signature%3DwyqX7xggACVcNK%252FDYYAjoXJJpa0%253D)
분명 전산학부 졸업 했는데 코딩 개못하는 조준호/기타2024. 6. 26. 12:47[MySQL] JOIN 연산의 종류
JOIN 연산: 두 개 이상의 테이블을 관련 열을 기준으로 결합 1️⃣ INNER JOIN SELECT columnsFROM table1INNER JOIN table2ON table1.column = table2.column; 둘 모두에서 겹치는 애들만 모음 SELECT employees.name, departments.department_nameFROM employeesINNER JOIN departmentsON employees.department_id = departments.department_id; 🙋♂️ INNER JOIN 빼고 나머지는 전부 OUTER JOIN인가요?👉 네. 2️⃣ LEFT JOIN SELECT employees.name, depar..