select A.* from 表名1 A left join 表名2 B on A.id=B.id where 1=1 order by A.id desc