sqlite> create table foo (a,b,c);
sqlite> create table bar (x,y);
sqlite> select * from foo where exists (select 1 from bar where foo.a = bar.x and foo.b = bar.y);
Replace the select 1 from bar
with your select ... many tuples of a/b values ...
.
Or create a temporary table of your select ... many tuples of a/b values ...
and use it in place of bar
..