Grouping Not Working
Posted by:
Lance Scott
Date: September 20, 2017 12:39AM
Hi
I'm having a problem getting grouping to work in my query, this is my query but it does not group by date, any ideas?
What I need is for it to group the results by week based on the date in Est_Ready
select MONTH(Est_Ready) as 'Month', WEEK(Est_Ready) as 'Week Ready', PU as 'Production Unit', sum(Item_Count) as ' Total Bunches', sum(Pred_Weight) as 'Total Weight (KGs)', Budgets_And_Loads.Farm_Budget as 'Farm Budget', Budgets_And_Loads.Revised_Budget as 'Revised Budget', Budgets_And_Loads.Local_Loads as 'Forcast Local Loads', Budgets_And_Loads.Mutare_Loads as 'Forcast Mutare Loads', Budgets_And_Loads.Export_Loads as 'Forcast Export Loads'
FROM Budgets_And_Loads
RIGHT JOIN BV_BE_Activation ON Budgets_And_Loads.Production_Unit = 8
GROUP BY WEEK(Est_Ready)
UNION
select MONTH(Est_Ready) as 'Month', WEEK(Est_Ready) as 'Week Ready', PU as 'Production Unit', sum(Item_Count) as ' Total Bunches', sum(Pred_Weight) as 'Total Weight (KGs)', Budgets_And_Loads.Farm_Budget as 'Farm Budget', Budgets_And_Loads.Revised_Budget as 'Revised Budget', Budgets_And_Loads.Local_Loads as 'Forcast Local Loads', Budgets_And_Loads.Mutare_Loads as 'Forcast Mutare Loads', Budgets_And_Loads.Export_Loads as 'Forcast Export Loads'
FROM Budgets_And_Loads
RIGHT JOIN BV_BH_Activation ON Budgets_And_Loads.Production_Unit = 8
GROUP BY WEEK(Est_Ready)
UNION
select MONTH(Est_Ready) as 'Month', WEEK(Est_Ready) as 'Week Ready', PU as 'Production Unit', sum(Item_Count) as ' Total Bunches', sum(Pred_Weight) as 'Total Weight (KGs)', Budgets_And_Loads.Farm_Budget as 'Farm Budget', Budgets_And_Loads.Revised_Budget as 'Revised Budget', Budgets_And_Loads.Local_Loads as 'Forcast Local Loads', Budgets_And_Loads.Mutare_Loads as 'Forcast Mutare Loads', Budgets_And_Loads.Export_Loads as 'Forcast Export Loads'
FROM Budgets_And_Loads
RIGHT JOIN BV_BP_Activation ON Budgets_And_Loads.Production_Unit = 8
GROUP BY WEEK(Est_Ready)