如题:
SELECT (SELECT ClassName
FROM NewsClass a where a.id=b.ClassID) AS MuName, *
FROM NewsContent b如果子查询有多行时出错,MuName这个列能否用一个函数返回所有行的结果?
SELECT (SELECT ClassName
FROM NewsClass a where a.id=b.ClassID) AS MuName, *
FROM NewsContent b如果子查询有多行时出错,MuName这个列能否用一个函数返回所有行的结果?
MuName=isnull(stuff((
select '、'+NewsClass from NewsClass a where a.id=b.ClassID
for xml path('')
),1,1,''),''),
*
FROM NewsContent b