Hi Guys,

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:
[CODE]
DAYS
Monday
Tuesday
Wednesday
Thursday

SELECT code FROM SSRMEET_MON_DAY UNION ALL
SELECT code FROM SSRMEET_TUE_DAY UNION ALL
SELECT code FROM SSRMEET_WED_DAY UNION ALL
....
SELECT code FROM SSRMEET_SUN_DAY

SELECT code  as DAYS
FROM SSRMEET_MON_DAY 
UNION ALL
SELECT code 
FROM SSRMEET_TUE_DAY 
UNION ALL
SELECT code 
FROM SSRMEET_WED_DAY 
UNION ALL
....
SELECT code 
FROM SSRMEET_SUN_DAY

SELECT *
FROM
(
SELECT code  as DAYS
FROM SSRMEET_MON_DAY 
UNION ALL
SELECT code 
FROM SSRMEET_TUE_DAY 
UNION ALL
SELECT code 
FROM SSRMEET_WED_DAY 
UNION ALL
....
SELECT code 
FROM SSRMEET_SUN_DAY
)t
WHERE DAYS ='Monday'