stuff() 函数用于将子查询内多个字段拼接到一起。
(STUFF((select distinct(','+d.TCXLXMC)
from TCXLX c join TC_TCXLX d on d.ID=c.xlxid join TC_TJ e on e.id=c.tcid
where e.TCID=tc.TCID AND d.SFXS=1 and d.tcdlxid='DL201505201452130001' for xml path('')),1,1,'')) AS [套餐类别]
stuff() 函数用于将子查询内多个字段拼接到一起。
(STUFF((select distinct(','+d.TCXLXMC)
from TCXLX c join TC_TCXLX d on d.ID=c.xlxid join TC_TJ e on e.id=c.tcid
where e.TCID=tc.TCID AND d.SFXS=1 and d.tcdlxid='DL201505201452130001' for xml path('')),1,1,'')) AS [套餐类别]