I would like to output the day that a lecture classes occurs.
Now each day is stored in a separate table. Each day is stored in a separate table. The word Monday is stored in a table called SSRMEET_MON_DAY, The word Tuesdays is stored in a table called SSRMEET_TUE_DAY ETC.
I am trying to extract all days in one column to then use a where clause to determine which day should be displayed in the report.
Therefore, I would like my table to look like:
Instead of :
And I don't have the privileges to create temporary tables.