mysql - 子查询返回超过 1 行，试图从 sku 获取今天和昨天的价格

Question

我正在尝试查询数据库以获取今天和昨天的 sku 价格。这是我的查询:

select ii2.SKU_config,

(select distinct bsh.unit_price
from tricae_business.bob_stock_history bsh
left join `data_warehouse`.item_info ii0 on ii0.id_item_info = bsh.id_catalog_simple
where date(bsh.date) = DATE_SUB(CURDATE(),INTERVAL 0 day) and ii0.sku_config = sku_config
group by ii0.sku_config) preco_hoje,
(select distinct bsh.unit_price
from tricae_business.bob_stock_history bsh
left join `data_warehouse`.item_info ii1 on ii1.id_item_info = bsh.id_catalog_simple
where date(bsh.date) = DATE_SUB(CURDATE(),INTERVAL 1 day) and ii1.sku_config = sku_config
group by ii1.sku_config) preco_ontem


from `data_warehouse`.item_info ii2
group by sku_config
limit 2

但我收到此错误:

Subquery returns more than 1 row

Answer 1

从外观上看，您正在从 data_warehouse.item_info ii2 中获取三列。在两个子查询之一中，您可能会抓取多行，这是不允许的。

尝试单独运行子查询并查看它们各自返回的内容