select count(yehuda.yehubh)as 拥有车辆数小于10的企业
from yehuda
left join cheliangxx on cheliangxx.yehubh=yehuda.yehubh
where (select count(yehuda.yehubh)as 企业拥有车辆数
from yehuda
inner join cheliangxx on cheliangxx.yehubh=yehuda.yehubh
)<10 and yehuzl='客运'select count(yehuda.yehubh)as 拥有车辆数小于10大于等于49的企业
from yehuda
left join cheliangxx on cheliangxx.yehubh=yehuda.yehubh
where (select count(yehuda.yehubh)as 企业拥有车辆数
from yehuda
inner join cheliangxx on cheliangxx.yehubh=yehuda.yehubh
)<50 and (select count(yehuda.yehubh)as 企业拥有车辆数
from yehuda
inner join cheliangxx on cheliangxx.yehubh=yehuda.yehubh
)>=10 and yehuzl='客运'select count(yehuda.yehubh)as 个体运输户
from yehuda
left join cheliangxx on cheliangxx.yehubh=yehuda.yehubh
where jingyingxz='个体' and yehuzl='客运'
怎么把这3条语句合成一条语句,不能用union,用一条记录显示
from yehuda
left join cheliangxx on cheliangxx.yehubh=yehuda.yehubh
where (select count(yehuda.yehubh)as 企业拥有车辆数
from yehuda
inner join cheliangxx on cheliangxx.yehubh=yehuda.yehubh
)<10 and yehuzl='客运'select count(yehuda.yehubh)as 拥有车辆数小于10大于等于49的企业
from yehuda
left join cheliangxx on cheliangxx.yehubh=yehuda.yehubh
where (select count(yehuda.yehubh)as 企业拥有车辆数
from yehuda
inner join cheliangxx on cheliangxx.yehubh=yehuda.yehubh
)<50 and (select count(yehuda.yehubh)as 企业拥有车辆数
from yehuda
inner join cheliangxx on cheliangxx.yehubh=yehuda.yehubh
)>=10 and yehuzl='客运'select count(yehuda.yehubh)as 个体运输户
from yehuda
left join cheliangxx on cheliangxx.yehubh=yehuda.yehubh
where jingyingxz='个体' and yehuzl='客运'
怎么把这3条语句合成一条语句,不能用union,用一条记录显示
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货