select a.*,b.* from tableA a, tableB b where a.id = b.id and a.name in (select a1.name from tableA a1 where 1=1 limit 1,10); 只需要一个sql不进行嵌套查询,这样应该
能实现一对多的分页查询
select a.*,b.* from tableA a, tableB b where a.id = b.id and a.name in (select a1.name from tableA a1 where 1=1 limit 1,10); 只需要一个sql不进行嵌套查询,这样应该能实现一对多的分页查询