SQL 왼쪽 안티조인

1 개요

SQL left anti join

SQL 왼쪽 안티 조인

2 예시: Sales & Countries

CREATE TABLE Sales (Date date, CountryID int(11), Units int(11));
INSERT INTO Sales (Date, CountryID, Units) VALUES
	('2020-01-01', 1, 40),
	('2020-01-02', 1, 25),
	('2020-01-03', 3, 30),
	('2020-01-04', 2, 35);

CREATE TABLE Countries (ID int(11), Country varchar(16));
INSERT INTO Countries (ID, Country) VALUES
	(3, 'Panama'),
	(4, 'Spain');

SELECT * FROM Sales
WHERE CountryID NOT IN ( SELECT ID FROM Countries );

3 같이 보기

• SQL 왼쪽 조인
• SQL 안티 조인
• SQL 오른쪽 안티 조인

4 참고

• https://docs.microsoft.com/en-us/power-query/merge-queries-left-anti