Multiple Concatenate and then Multiple Join Tables

[Eli181]

Hi. 

Here is the following problem:

I have 7 tables: A, B, C, D, E, F, and M.

1.  I have to concatenate the first 3 (A, B, C) as ABC Table  ... with a Product ID
2. I have to concatenate the next 3 (D, E, F) as DEF Table ... that carries the same Product ID but other fields
3. I have to outer join ABC Table to M as MABC ... along same Product ID but more fields
4. I have to outer join DEF Table to MABC as MABCDEF ... alond same product ID

or the other option is to

1. Outer Join ABC and DEF for a ABCDEF table, and 
2. Outer Join M to ABCDEF.

What would be the script to address this issue?

I was able to run 1, and then 3 ... but then the join with DEF duplicates rows rather than "merge" rows (as it would be said in PowerBi)

Thank you for your help.

JM

[jerifortune]

In Step 1 and 2, do you mean Left JOIN or Concatenate (Union)?