I have two tables.
table 1 : ref_forecast_won
This table has the total number of actual sales from year to date, grouped by country and month.
Table 2 ref_forecast_amount
This table has the total number of opportunities being worked on from now to the end of year, grouped by country and month.
I want to join both tables together. So I have the following columns
Total Worked on.
from ref_forecast_won w
left join ref_forecast_amount a on a.month = w.month and a.market = w.market
My query shows me all data up until month 9 (September) , Where it should me all of the opportunities worked on beyond this date.
Can someone please help?