table AID Time content
。table B:
id time
只要是A中的ID,time符合
select id,time from B where ...
的记录,我都删掉这种语句怎么写啊类似下面的逻辑,但是下面的语法不正确
delete form A where id,time in(
select id,time from B where ...
)
。table B:
id time
只要是A中的ID,time符合
select id,time from B where ...
的记录,我都删掉这种语句怎么写啊类似下面的逻辑,但是下面的语法不正确
delete form A where id,time in(
select id,time from B where ...
)
DELETE FROM A
WHERE EXISTS (SELECT 1
FROM B
WHERE A.ID = B.ID
AND A.TIME = B.TIME)