1

I need to join an existing table with date entries with a list of months in a given period. For this I would need to temporary generate a list of months within this period.

Is there a command in mysql for doing this? Temporary Table, stored procedure?

Thx, martin

Carson Myers
  • 37,678
  • 39
  • 126
  • 176
Martin
  • 645
  • 1
  • 9
  • 19

1 Answers1

1

I'm not sure I fully understand your question, but something like this might be what your looking for:

select * from existing_table et join month_table mt on mt.month = month(et.date)