I have two tables (table a) has data like this
(table b) has data like this
I need a query that gives me the following results
Year | Month
I'm OK on parsing the date from table A and grouping the years in table B, but I'm not sure how to join them. The idea is that when a 2010 record is added (in the beginning of 2010) I get...
and so on.. thanks in advance