语句： 1、select a.* from table_a a,table_b b where b.id in (‘1’,‘2’,‘3’) and a.con =b.con 2、select a.* from table_a where a.con in (select con from id in (‘1’,‘2’,‘3’)) 条件： 1、table_a表的con字段是索引，table_b