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))