可以用连接吧!你可以去查一下用什么连接方式适合你的需求SQL的几种连接:内连接、左联接、右连接、全连接、交叉连接内连接select * from table1 as a inner join table2 as b on a.aa = b.aa and a.bb=bb
Where aa in (1,2,3,4,5) or bb in (1,2,3,4,5)