67,513
社区成员
发帖
与我相关
我的任务
分享
select * from (
select a.*, b.字段1, b.字段2 from A a, B b
where a.id = b.aid order by b.createtime desc
) c where rownum = 1
select a.*, b.字段1, b.字段2 from A a, B b
where a.id = b.aid
and b.createtime = (select max(createtime) from B c where c.id = b.id)