![](https://img1.daumcdn.net/thumb/R750x0/?scode=mtistory2&fname=https%3A%2F%2Fblog.kakaocdn.net%2Fdn%2Fby9eF6%2Fbtr34BvC9f0%2FKPGiFXjuDqeMITvMgdSc3K%2Fimg.png)
SQL | MySQL | 테이블 집합 연산 - UNION, UNION ALL 등
·
SQL
✅ 예제 테이블 생성 CREATE TABLE employees ( employee_id INT PRIMARY KEY, first_name VARCHAR(50), last_name VARCHAR(50), department_id INT ); CREATE TABLE departments ( department_id INT PRIMARY KEY, department_name VARCHAR(50) ); INSERT INTO employees (employee_id, first_name, last_name, department_id) VALUES (1, 'John', 'Doe', 1), (2, 'Jane', 'Smith', 2), (3, 'Bob', 'Johnson', 1), (4, 'Alice', 'Brown'..