mysql 连接2张表查数据

[qq_36022901]

[S写意]

给第二个循环加一个if判断，所有外键与张三逐渐相等的显示，其余的不显示

[一起混吧]

试试 select a.id,a.name, group_concat(sub) from student a left join subject b on a.id=b.id group by b.id

[lyshensir]

引用 2 楼 jordan102 的回复:

试试 select a.id,a.name, group_concat(sub) from student a left join subject b on a.id=b.id group by b.id

棒棒的！

[君King]

group_concat() 将相同数据拼接

[落叶秋2020]

select a.id,a.name, group_concat(b.Sub) AS sub from student a left join subject b on a.id=b.id group by b.id 以上SQL是可以的