Questions regarding joins

gualco — Mon, 03 Jul 2023 14:44:04 GMT

Hello,

I have two tables I would need to join. Can you guys recommended me what would be the best ?

Table1

Table2

Calendar Year | Country | Product Type | Volume Forecasted

I need to join the two to be able to calculate to compare the Volume bought (group by Country, Product Type and Calendar) vs the Volume Forecast.

thank you very much

Re: Questions regarding joins

RADSr — Mon, 03 Jul 2023 16:43:22 GMT

It looks like you are describing a one to many relationship table 1 to table 2 in which case table 1 would be the child and table 2 the parent.

Depending upon what else will be in your schema I might go ahead and create an MV combining them, but the child-parent join should work for you.