DELETE FROM BB_USER_PRODUCT_INFO_T a
WHERE a.F_USER_ID = in_user_id
AND EXISTS(
SELECT a.f_item_id FROM bb_product_prechange_t c
WHERE c.f_user_id = a.f_user_id
AND c.f_item_id = a.f_item_id
AND c.action = 1
)
AND f_begin_date > SYSDATE;
delete exist
最新推荐文章于 2022-08-17 18:41:06 发布