22,206
社区成员
发帖
与我相关
我的任务
分享
select *,(select a from c where cid=b.bid) as sheng from b order by sheng
select b.*,c.a sheng from b left join c on b.bid=c.cid order by sheng
select b.*,c.a sheng from b left join c on b.bid=c.cid order by sheng
select a.*,c.a sheng from b left join c on b.bid=c.cid order by sheng
那在外层再加一个select ,如:
select * from
(
select *,(select a from c where cid=b.bid) as sheng from b
)aa
order by sheng