摘要： select * from tblA as a left join tblB as b on a.id=b.a_id where 1 order by b.a_id desc limit 10; order by，tblB的索引影响排序。 阅读全文