17,377
社区成员
发帖
与我相关
我的任务
分享
select a.id ,max(a.name),max(b.id),max(b.name) from A a ,B b where a.id = b.aid
group by a.id
select a.id ,max(a.name),max(b.id),max(b.name) from A a ,B b where a.id = b.aid
group by a.id
select a.id ,b.id,max(a.name),max(b.name) from A a ,B b where a.id = b.aid
group by a.id, b.id