MySQL – 操作数应包含1列

查询某个时间段的进销存  以下语句运行提示：操作数应包含1列

select b.goodarrtime as 进货日期,a.goodname as 药品名称,a.DoesType as 剂型,a.Style as 规格,
(select SUM(stkqty) from jxc_good_batch where LatelyBuyTime<='2021-02-28' and LatelyBuyTime>='2020-12-01' GROUP BY goodcode) as 库存数量,
b.stkqty as 购进数量,
a.NewPurcPrice as 进价,
(SELECT * FROM jxc_trd_salelist where trdtime<='2021-02-28' and trdtime>='2020-12-01' GROUP BY goodcode) as 销售数量,
a.SalePrice as 售价,
(select SUM(stkqty) from jxc_good_batch where  LatelyBuyTime<='2021-02-28' and LatelyBuyTime>='2020-12-01' GROUP BY goodcode) as 盘存数量
from jxc_good_baseinfo a,(select goodcode,sum(quantity) as stkqty,goodarrtime from jxc_trd_buylist where goodarrtime<='2021-02-28' and goodarrtime>='2020-12-01' GROUP BY goodcode) b
where a.goodcode=b.goodcode

检查一下这里，返回了多列

(SELECT * FROM jxc_trd_salelist where trdtime<='2021-02-28' and trdtime>='2020-12-01' GROUP BY goodcode) as 销售数量

查询数量一般会用count(*)。

您好，我是有问必答小助手，你的问题已经有小伙伴为您解答了问题，您看下是否解决了您的问题，可以追评进行沟通哦~

如果有您比较满意的答案 / 帮您提供解决思路的答案，可以点击【采纳】按钮，给回答的小伙伴一些鼓励哦～～

ps:问答VIP仅需29元，即可享受5次/月 有问必答服务，了解详情>>> https://vip.csdn.net/askvip?utm_source=1146287632