求DB2 delete sql 语句
CREATE
TABLE X
(
A VARCHAR(10) NOT NULL,
B INTEGER NOT NULL,
CONSTRAINT CC1315882009531 PRIMARY KEY (A, B)
);

CREATE
TABLE Y
(
A VARCHAR(10) NOT NULL,
B INTEGER NOT NULL,
CONSTRAINT CC1315882056921 PRIMARY KEY (A, B)
);

TABLE X
A B
--------------
101
102
201
202
301
302
303
304
403
404

TABLE Y
A B
--------------
101
102
103
104
201
202
203
204

求一条SQL，将Y表中与X表重复的数据删除，即从Y表删除下列查询结果的数据：
SELECT x.a,x.b FROM x,y where x.a=y.a and x.b=y.b
101
102
201
202



[解决办法]

SQL code

delete from Y where exists (  select * from X where X.A = Y.A and X.B = Y.B)
[解决办法]
试试
delete from  
(select y.* from y left join x on  X.A = Y.A and X.B = Y.B where x.a is not null) t