我需要修复“当EXISTS没有引入子查询时,只能在选择列表中指定一个表达式”

时间:2020-11-28 09:06:26

I have the following query, but I am receiving this error:

我有以下查询,但我收到此错误:

Only one expression can be specified in the select list when the subquery is not introduced with EXISTS.

当未使用EXISTS引入子查询时,只能在选择列表中指定一个表达式。

(select replace((stuff (itemdata,1,66,'')), '<BodyText>', '')as text
 from charts
 where itemtype = 'DocumentItems_RichText' and checksum ='1'
 union all
 select stuff (itemdata,1,66,'')
 from charts
 where itemtype = 'DocumentItems_RichText'
 and checksum <>'1' )AS Content

1 个解决方案

#1


0  

You can try this:

你可以试试这个:

SELECT Content
FROM
(
 select replace((stuff (itemdata,1,66,'')), '<BodyText>', '')as text
 from charts
 where itemtype = 'DocumentItems_RichText' 
    and checksum ='1' 
 union all 
 select stuff (itemdata,1,66,'')
 from charts
 where itemtype = 'DocumentItems_RichText'
    and checksum <>'1' 
) DS (Content);

#1


0  

You can try this:

你可以试试这个:

SELECT Content
FROM
(
 select replace((stuff (itemdata,1,66,'')), '<BodyText>', '')as text
 from charts
 where itemtype = 'DocumentItems_RichText' 
    and checksum ='1' 
 union all 
 select stuff (itemdata,1,66,'')
 from charts
 where itemtype = 'DocumentItems_RichText'
    and checksum <>'1' 
) DS (Content);