子查询返回的值不止一个。我这个里面的查询结果不止一个，请问怎么改？

Question

SELECT a.RecordIdVch, a.TaskIdVch,d.SiliconLenthVch, a.BoxBarVch, a.GrossWeightDbl, a.NetWeightDbl,
(select NetWeightDbl from YRemoveRecord where WorkShopVch='B1') as WeightDbl1,
(select NetWeightDbl from YRemoveRecord where WorkShopVch='B2') as WeightDbl2,
a.FurnaceNoVch, a.ResistanceDbl, a.GrowthTimeDbl ,f.CateNameVch, g.CateNameVch as size,a.FurnaceNoVch as FurnaceNoVch2,
CASE a.IsFallDownVch WHEN 'Y' THEN '是' ELSE '否' END AS FallDownName,a.OperaterVch,a.OperateDt,
CASE a.IsCleaningVch WHEN 'Y' THEN '是' ELSE '否' END AS CleaningName,
a.CombinStateVch,
(SELECT COUNT(1) FROM YRemoveRelation b WHERE b.RecordIdVch=a.RecordIdVch) AS RelationNum,
c.MasterCodeVch,c.MasterNameVch,d.TaskNoVch,d.RealName,d.WorkShopIdVch,d.TOGNameVch,d.StateName,d.TaskStateVch,
e.DicNameVch 'CombinState'
FROM YRemoveRecord a
INNER JOIN dbo.View_YRemoveTask d ON a.TaskIdVch=d.TaskIdVch
INNER JOIN dbo.BMaster c ON a.MasterCodeVch=c.MasterCodeVch
INNER JOIN dbo.BDictionary e ON a.CombinStateVch=e.DicCodeVch AND e.UpCodeVch='BinType'
inner join BMasterCate f on a.SiliconTypeVch=f.CateCodeVch and f.CateTypeVch='CT07'
inner join BMasterCate g on a.SiliconTypeVch=g.CateCodeVch and g.CateTypeVch='CT02'

Answer 1

把这个：
(select NetWeightDbl from YRemoveRecord where WorkShopVch='B1') as WeightDbl1,
(select NetWeightDbl from YRemoveRecord where WorkShopVch='B2') as WeightDbl2,
改成下面：
case WorkShopVch when B1 then NetWeightDbl end WeightDbl1,
case WorkShopVch when B2 then NetWeightDbl end WeightDbl2,