Suppose that I have two tables:
tableA (id, name); tableB (id, name);
I also have a textual file with a list of couples of ids:
id1a, id2a id1b, id2b ...
I would like to run the following query:
select * from ( id1a, id2a id1b, id2b ...) join tableA as a on a.id = id1 join tableB as b on b.id = id2;
How can I write such a query?