select * from table2 left join table1 on table2.tid=tabl1.tid where table1.status=1 order by table2.time desc, table1.tid这样试试,应该可以
第一条 select * from table2 left join table1 on table2.tid=tabl1.tid where table1.status=1 and table1.displayorder=0 order by table1.tid第二条 select * from table2 left join table1 on table2.tid=tabl1.tid where table1.status=1 and table1.displayorder>0 order by table2.time
select * from table2 left join table1 on table2.tid=tabl1.tid where table1.status=1 and table1.displayorder=0 order by table1.tid第二条
select * from table2 left join table1 on table2.tid=tabl1.tid where table1.status=1 and table1.displayorder>0 order by table2.time