select lang +',' from M_LANG l inner join  sel_lang s on l.LID=s.lcode  where mcode in('000001') for xml path('')

SELECT (
   select lang +',' from M_LANG l inner join  sel_lang s on l.LID=s.lcode  where mcode in('000001') for xml path('')
   ) as Language

SELECT Language 
FROM
(
SELECT STUFF((select lang +',' from M_LANG l inner join  sel_lang s on l.LID=s.lcode  where mcode in('000001') for xml path('')),1,1,'') AS Language
)t

quote:

---

Originally posted by visakh16

SELECT Language 
FROM
(
SELECT STUFF((select ','+lang  from M_LANG l inner join  sel_lang s on l.LID=s.lcode  where mcode in('000001') for xml path('')),1,1,'') AS Language
)t

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

---

quote:

---

Originally posted by James K

quote:

---

Originally posted by visakh16

SELECT Language 
FROM
(
SELECT STUFF((select ','+lang  from M_LANG l inner join  sel_lang s on l.LID=s.lcode  where mcode in('000001') for xml path('')),1,1,'') AS Language
)t

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

---

A little fixing up

---