表A
Aid Aname
1 aa
2 bb
3 cc
4 dd
5 ee 表B
Aid Cid
1 1
1 2
2 1
3 3
3 6
5 6
表C
Cid Cname
1 qq
2 vc
3 C#
4 C++
5 sql
6 mysql我想根据以上3张表的数据得到以下结果:通过一条sql语句在mysql里实现Aname Cname
aa qq,vc
bb qq
cc C#,mysql
dd
ee mysql
Aid Aname
1 aa
2 bb
3 cc
4 dd
5 ee 表B
Aid Cid
1 1
1 2
2 1
3 3
3 6
5 6
表C
Cid Cname
1 qq
2 vc
3 C#
4 C++
5 sql
6 mysql我想根据以上3张表的数据得到以下结果:通过一条sql语句在mysql里实现Aname Cname
aa qq,vc
bb qq
cc C#,mysql
dd
ee mysql
from a left join b on a.Aid=b.Aid
left join c on a.Cid=v.Cid
group by a.name
from A left join B on A.aid=B.aid left join C on B.cid=C.cid
group by A.Aname
from a left join b on a.Aid=b.Aid
inner join c on a.Cid=v.Cid
group by a.name