select paypno as 放款计划编号,

group_concat(concat(loano,'-',custname) separator ',') as '订单号-客户姓名'

 from payp_item a

 group by paypno

本文转自 leizhimin 51CTO博客，原文链接：http://blog.51cto.com/lavasoft/1956016，如需转载请自行联系原作者