insert into main_table values

(1, 1, 1, '2025-02-28 14:45:11'),

(2, 2, 2, '2025-02-28 14:45:11');

create table month_table (id int, month varchar(31));

insert into month_table values (1, 'January'), (2, 'February');

create table Jan_weeks (id int, week varchar(31));

insert into Jan_weeks values (1, 'Week 1 is in January');

create table Feb_weeks (id int, week varchar(31));

insert into Feb_weeks values (2, 'Week 2 is in February');

(

SELECT 1 AS `month`, w.* FROM Jan_weeks w

UNION ALL

SELECT 2, w.* FROM Feb_weeks w

)

SELECT main_table.id AS `id`,

month_table.month AS `month`,

week_table.week AS `week`

FROM main_table

INNER JOIN month_table AS month_table ON main_table.month = month_table.id

INNER JOIN week_table AS week_table ON main_table.week = week_table.id AND main_table.month = week_table.month;