当没有用 EXISTS 引入子查询时，在选择列表中只能指定一个表达式。这个sql语句应该怎么改？

Question

select convert(char(10),OperateDt,120),FurnaceNoVch,SiliconLenthVch,CateNameVch,size,WeightDbl1,WeightDbl2,sum(WeightDbl1) as newWeightDbl1,
(select convert(char(10),OperateDt,120),sum(NetWeightDbl) from YRemoveRecord group by convert(char(10),OperateDt,120)) as AsnewWeightDbl,
FurnaceNoVch2,FallDownName,MasterNameVch,MasterCodeVch
from View_YRemoveRecord where 1=1
group by convert(char(10),OperateDt,120),FurnaceNoVch,SiliconLenthVch,CateNameVch,size,WeightDbl1,WeightDbl2,FurnaceNoVch2,FallDownName,MasterNameVch,MasterCodeVch

Answer 1

可以使用in.....................