怎么让数据库按2个字段值合并重复的并把其他属性横向输出

SELECT

product.pro_name,

product.pro_color,

product.pro_spec,

xsmx.mx_num

FROM xs,   
     xsmx, 
     product    

where ( xs.xs_hao = xsmx.xs_hao ) and

( xsmx.pro_id = product.pro_id ) and

( xs.xs_hao ='XS20160422001' )

数据是从几个表里 链接按xs_hao提取的！
怎么做到让name和color一样的值合并 并且把num按 spec对应的值横向输出在新建的列里

http://www.cnblogs.com/luluping/archive/2012/07/26/2610705.html