Firebird 4.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
select rdb$get_context('SYSTEM', 'ENGINE_VERSION') as version
     , rdb$character_set_name
from rdb$database;


VERSION
RDB$CHARACTER_SET_NAME


4.0.1
UTF8


create table TABLE1 (ID integer primary key)
execute block
as
begin
  insert into TABLE1 (ID) values (1);
  insert into TABLE1 (ID) values (2);
  insert into TABLE1 (ID) values (3);
  insert into TABLE1 (ID) values (4);
  insert into TABLE1 (ID) values (5);
end
5 rows affected

create table TABLE2 (ID integer, ID1 integer, ID2 integer)
execute block
as
begin
  insert into TABLE2 (ID, ID1, ID2) values (1, 0, 0);
  insert into TABLE2 (ID, ID1, ID2) values (2, 422682, 2451685);
  insert into TABLE2 (ID, ID1, ID2) values (3, 0, 0);
  insert into TABLE2 (ID, ID1, ID2) values (4, 422682, 2451685);
  insert into TABLE2 (ID, ID1, ID2) values (5, 0, 0);
end
5 rows affected

select * from table1 order by id


ID


1

2

3

4

5


merge into TABLE1
using (
  select ID
  from TABLE2
  where ID1 = 422682 and ID2 = 2451685
) as SRC
on SRC.ID = TABLE1.ID
when matched then delete
2 rows affected

select * from table1 order by id


ID


1

3

5