A表为主表，B表中有A表ID多数据，想排序不知道是否可行

[CaRrot_Love]

因为想偷懒 绑定前台repeater控件默认的集合为 select * from A 返回的集合 现在想用B表中数量来进行排序 所以想以 select * from A order by (?) 进行排序 问号就要用到B表在A的数量 类似 (

select count(AID) from B group by AID

) 直接写这句在order by 后是有错误的 我这种想法是否能实现 还是只能用其他方法解决 求大大~

[习惯性蹭分]

select a.* from A
left join (select AID,count(1) as cnt from B group by AID) B
on A.id=B.AID
order by B.cnt

[CaRrot_Love]

引用 1 楼 tangguangqiang 的回复:

select a.* from A
left join (select AID,count(1) as cnt from B group by AID) B
on A.id=B.AID
order by B.cnt

谢谢大大 实测可以