Delete row from table where match exists in second table
In MSSQL you can do this: (most efficient)
DELETE a FROM a JOIN b ON a.ID1 = b.ID1 AND a.ID2 = b.ID2
DELETE a FROM TableA a INNER JOIN TableB b ON a.ID1=b.ID1 AND a.ID2=b.ID2
How about: (not too sure whether this works in SQLite)
DELETE FROM TableA
WHERE EXISTS (SELECT *
FROM TableB
WHERE TableB.ID1 = TableA.ID1
AND TableB.ID2 = TableA.ID2)