users
user3
all
: 모든 결과 확인select * from `weniv.weniv_user` as user1
UNION ALL
select * from `weniv.weniv_user3` as user3
order by id
distinct
: 중복 제거select * from `weniv.weniv_user` as user1
UNION DISTINCT
select * from `weniv.weniv_user3` as user3
order by id
INTERSECT DISTINCT
이렇게 만 있음select * from `weniv.weniv_user` as user1
INTERSECT DISTINCT
select * from `weniv.weniv_user3` as user3
order by id
EXCEPT 첫 번째 결과 집합에는 나타나지만 두 번째 결과 집합에는 나타나지 않는 행만 반환합니다.
select * from `weniv.weniv_user` as user1
except DISTINCT
select * from `weniv.weniv_user3` as user3
order by id