Loop in the DB structure

[#1]

Hi,

I have an issue,

I have several big tables that can't be concatenated (because they are too big):

Table1

RegionA

YearA

MonthA

DimA

DimB

DimC

Table2

RegionB

YearB

MonthB

DimD

DimE

DimF

I want to create a common filter to be able to select the region, the year, the month for both of the tables.

If I use a Third  table (inline) like this to create a link between the tables it works:

MasterFilterYear:

MasterYear, YearA, YearB

2015, 2015, 2015

2016, 2016, 2016

But if I do an other one for Region it creates a loop in the structure:

MasterFilterRegion:

MasterRegion, RegionA, RegionB

Asia, Asia, Asia,

America, America, America

Can you help me to create this "Master Filter" please ? Thanks

[#2]

I just made an outer join between my main filter tables:

MasterFilterYear

MasterFilterRegion

MasterFilterMonth

It works. But is it a good practice ?