select * from b where 时间字段 > (select 时间字段 from a where a.id=xxxx) litmi 1;
a
id time
1 324523
2 234324
b
id aid time
1 2 234
2 2 5435
3 1 34543
4 1 32543
select * from (select b.* from b
join a on b.id = a.id and b.time < a.time
order by b.aid, b.time desc ) as c group by c.aid ;
内容全部来源于网络收集，如有侵权，请联系网站删除：QQ：24596024