MYSQL #1241 错误消息

Question

我正在尝试从两个日期之间的表中提取数据并将其相加得到一个数字。我的代码如下:

SELECT Total_Rode, SUM(Total_Rode)
FROM Sales 
WHERE Sales.Sales_Date BETWEEN DATE_SUB(Budget.Budget_Date, INTERVAL 364 DAY) 
AND DATE_SUB(Budget.Budget_Date, INTERVAL 357 DAY) 
AND Sales.Company = '98'
GROUP BY Total_Rode

我不断收到错误消息“数据库错误:执行查询时出现问题。(操作数应包含 1 列)#1241

Answer 1

您错过了加入预算表

SELECT Total_Rode, SUM(Total_Rode)
FROM Sales 
join Budget 
on sales.commoncolumn = Budget.commoncolumn
WHERE Sales.Sales_Date BETWEEN DATE_SUB(Budget.Budget_Date, INTERVAL 364 DAY) 
AND DATE_SUB(Budget.Budget_Date, INTERVAL 357 DAY) 
AND Sales.Company = '98'
GROUP BY Total_Rode