34,590
社区成员
发帖
与我相关
我的任务
分享
select * from a t order by (select max(time) from b where id = t.id)
SELECT A.*,T.TIME FROM A
LEFT JOIN T
ON A.ID=T.ID
ORDER BY T.TIME
select * from a t order by (select time from b where id = t.id)
select a.* from a left join b on a.id = b.id order by b.time