22,297
社区成员
发帖
与我相关
我的任务
分享SQL的fulljoin与leftjoin连接两个表，求教
求教，为了横向连接两个sql，一开始用的fulljoin，结果报错，改成leftjoin就没问题（仅仅full改成left，其他没有动），求教fulljoin和leftjoin编写上哪里的问题
Full join语句：
select a1.city,a1.yici,a2.liangci
from
(select city, count(cishu) as yici
from jituan_ceshi
where cishu ='1.0'
group by city) as a1
full join
(select city,count(cishu) as liangci
from jituan_ceshi
where cishu ='2.0'
group by city) as a2
on a1.city=a2.city
order by a1.city
Left join语句：
select a1.city,a1.yici,a2.liangci
from
(select city, count(cishu) as yici
from jituan_ceshi
where cishu ='1.0'
group by city) as a1
left join
(select city,count(cishu) as liangci
from jituan_ceshi
where cishu ='2.0'
group by city) as a2
on a1.city=a2.city
order by a1.city
...全文
请发表友善的回复…
发表回复
tengfeictf 2023-08-10
- 打赏
- 举报
a1和a2两个SQL单独运行都能出结果
