Postgres 12

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE myitemtable(numcolA int, numcolB int);
INSERT INTO myitemtable VALUES
  (1, 1)
, (1, 2)
, (2, 5)
, (2, 9);

CREATE TABLE some_items_table (num_col1 int, num_col2 int);
INSERT INTO some_items_table VALUES
  (1, 2)
, (2, 9);

CREATE TABLE

INSERT 0 4

CREATE TABLE

INSERT 0 2

DELETE FROM myitemtable m
USING  some_items_table s
WHERE (m.numcolA , m.numcolB) IN ((s.num_col1, s.num_col2), (1,1), (1,3), (2,2), (2,8), (2,10), (3,9));

DELETE 3

TABLE myitemtable;

numcola
numcolb

2
5

SELECT 1