Question

sqlserver里报子查询返回的值不止一个。当子查询跟随在 =、!=、<、<=、>、>= 之后，或子查询用作表达式时

SELECT
p.ProductID,
p.MerchantID,
m.ShopName,
m.Mobile,
m.Address,
p.ProductName,
p.DESCRIBE,
(SELECT gb.Price FROM sys_ProductFeature gb WHERE gb.ProductID = p.ProductID) AS Price,
p.TypeID,
pi.ImgFile,
'recom' AS buyType
FROM
(SELECT * FROM sys_Product WHERE ProductID IN (SELECT DISTINCT pp.ProductID from sys_ProductPopedom pp WHERE pp.AccountType IN (SELECT a.AccountType FROM sys_Account a WHERE a.ObjectID = '201709064615'))) p
LEFT JOIN sys_ProductType pt ON pt.Product_Type_ID = p.TypeID
LEFT JOIN sys_Merchant m ON p.MerchantID = m.MerchantID
LEFT JOIN (SELECT pi2.ProductID,
(select top 1 ImgFile from sys_ProductImg pi1 where pi2.ProductID = pi1.ProductID) as ImgFile,
(select top 1 FeatureID from sys_ProductImg pi1 where pi2.ProductID = pi1.ProductID) as FeatureID
from sys_ProductImg pi2 group by ProductID) as pi on pi.ProductID = p.ProductID
WHERE
pi.FeatureID = 0
AND p.State = 1
求大神帮我看看...感谢

Answer 1

(SELECT gb.Price FROM sys_ProductFeature gb WHERE gb.ProductID = p.ProductID) AS Price
这里估计返回不止一条数据 加个 top 1