show (value1,value2) in one column in sql
declare @edition varchar(100) select @edition = STUFF((SELECT '/' + newspaperedition FROM ADVT_REQUEST INNER JOIN NEWBILL ON ADVT_REQUEST.RO_CODE = NEWBILL.ROCODE INNER JOIN MRADDRESS ON NEWBILL.NP_CODE = MRADDRESS.np_code WHERE New_ROCode = '1137/13/64/2021/71753/31/3' FOR XML PATH('')), 1, 1, '')