SQL IN 多字段行匹配

2024-08-02 / SQL / KOGU

SQL IN 匹配多个字段的用法：

select * from t where (a, b) in ((1, 2), (3, 4))

select t1.a,t2.b from t1 left join t2 on t1.c=t2.d where (t1.a, t2.b) in ((1, 2), (3, 4))