I have two tables
- table Calendar as Cal
- with 32 columns :
each day of the calendar contains an id_overview (from 1...1000)
- table OverviewCode 'code'
- with all the id's (1...1000, and their descriptions)
For each column cal.id_overviewcode(n1...31)
I would like it joined together and view both the
id_overviewcode with the description.
I can join it to one column but how could I join it to multiple columns efficiently?
from calendar cal
inner join overviewcode code on cal.id_overviewcode1 = code.id_overviewcode