Merging dates and day of the week.

Hi Everyone,

I have two tables with one common column with the date in form of month and day (eg Jan 1). The first table has in addition user accounts. The second doesn’t have user account but has the month, day and day of the week (eg Monday). How does one create one table that combines both user account, month, date and day of the week? The idea is to create a table of failed user logins on weekends Saturday and Sunday)