In my opinion, the result can be achieved using a join:

SELECT column1, column2, column 3
    FROM  table
    join table2 on
    table.column1 = table2.c1
    and
    table.column2 = table2.c2