MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE X(A varchar(20), B int, C varchar(20));
insert into X values ('甲',1,'001');
insert into X values ('乙',2,'001');
insert into X values ('丙',3,'001');
insert into X values ('丁',4,'001');
insert into X values ('己',5,'001');
CREATE TABLE Y(A varchar(20), B int, C varchar(20));
SELECT *
FROM X


A
B
C


甲
1
001

乙
2
001

丙
3
001

丁
4
001

己
5
001


insert into Y values ('甲',1,'002');
insert into Y values ('乙',2,'001');
insert into Y values ('丙',3,'001');
insert into Y values ('丁',4,'002');
insert into Y values ('戊',5,'001');
SELECT *
FROM Y


A
B
C


甲
1
002

乙
2
001

丙
3
001

丁
4
002

戊
5
001


SELECT X.* 
FROM X
LEFT JOIN Y ON 
X.A=Y.A AND X.B=Y.B AND X.C=Y.C
WHERE 1=1
AND Y.A IS NULL AND Y.B IS NULL AND Y.C IS NULL;


A
B
C


甲
1
001

丁
4
001

己
5
001