```
select PRODUCTPRICEPLANID,PRICEPLANDESCRIPTION,OPERATORNAME,SOCCODE from 
                (SELECT  
                ppp.PRODUCTPRICEPLANID,
                ps.PRICEPLANDESCRIPTION,
                O.OPERATORNAME,
                osoc.SOCCODE
FROM PRODUCTPRICEPLAN ppp 
join PRICEPLANSUMMARY ps 
on ppp.PRODUCTPRICEPLANID=ps.PRODUCTPRICEPLANID_FK 
join PRICEPLANSOC psoc 
on ppp.PRODUCTPRICEPLANID=psoc.ProductPricePlanID_FK
join OPERATORSOC osoc 
on psoc.OPERATORSOCID_FK=osoc.OPERATORSOCID
join operators o on osoc.OPERATORID_FK=O.OPERATORID
where ppp.PRODUCTPRICEPLANID=95) t 
GROUP BY  PRODUCTPRICEPLANID,PRICEPLANDESCRIPTION,OPERATORNAME,SOCCODE

```

Currently I am getting this result set from my query:

```
PRODUCTPRICEPLANID  PRICEPLANDESCRIPTION    OPERATORNAME    SOCCODE
 95                    TMUS UnBundled        T-Mobile US     BRVC
 95                    TMUS UnBundled        T-Mobile US    INROAM

```

But i want this:

```
PRODUCTPRICEPLANID  PRICEPLANDESCRIPTION    OPERATORNAME    SOCCODE
 95                    TMUS UnBundled        T-Mobile US     BRVC,INROAM

```