sql - 内部连接与Apache derby的delete语句

Question

我使用以下语法来选择所需的行:

select * from Customer_Coupon inner join Company_Coupon on
Customer_Coupon.COUPON_Id =Company_Coupon.COUPON_Id where COMP_Id = 123;

我应该使用什么语法删除同一行？

Answer 1

可以将DELETE statment与IN运算符一起使用:

DELETE FROM Customer_Coupon WHERE COUPON_ID IN (
   SELECT COUPON_ID FROM Customer_Coupon INNER JOIN Company_Coupon ON
   Customer_Coupon.COUPON_Id =Company_Coupon.COUPON_Id WHERE COMP_Id = 123
);

这将删除Customer_Coupon表中内部SELECT返回 COUPON_ID的所有行。