Thanks a lot, using the CTE,I received the right result. with my_table(a,b) as( values(1,2),(3,4) ) SELECT * FROM tt WHERE (a,b) IN (SELECT a,b FROM my_table);
Thanks a lot, using the CTE,I received the right result. with my_table(a,b) as( values(1,2),(3,4) ) SELECT * FROM tt WHERE (a,b) IN (SELECT a,b FROM my_table);