i have below query using for xml path
i get the desired output but how do i use as for renaming the column in the output
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
whts the syntax , not able to use as