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对应的值横向输出在新建的列里