可以使用MySQL中group_concat函数 完整的语法如下: group_concat([DISTINCT] 要连接的字段 [Order BY ASC/DESC 排序字段] [Separator '分隔符']),默认分隔符是“,” select A.name, group_concat(B.name) from A,B where A.id = B.tid group by A.name;
select A.name, group_concat(B.name separator '||') from A,B where A.id = B.tid group by A.name; 结果会以“||”分隔。
select a.id,group_concat(b.f1) from a inner join b on a.id=b.id group by a.id
from a ,b
where a.companyid=b.companyid
group by a.companyid
http://topic.csdn.net/u/20090501/15/7548d251-aec2-4975-a9bf-ca09a5551ba5.html
完整的语法如下:
group_concat([DISTINCT] 要连接的字段 [Order BY ASC/DESC 排序字段] [Separator '分隔符']),默认分隔符是“,”
select A.name, group_concat(B.name) from A,B where A.id = B.tid group by A.name;
结果会以“||”分隔。