select id,mcheng=(stuff((select ',' + (mcheng+' '+bfbi+'%') from Rx_rybom where id = A.id for xml path('')),1,1,''))from Rx_rybom as A group by id
select id,mcheng=(stuff((select ',' + (mcheng+' '+bfbi+'%') from Rx_rybom where id = A.id for xml path('')),1,1,''))from Rx_rybom as A group by id