Hi there,
I am trying to combine data from 3 tables into 1 table using a common identifier (ID). For 2 tables, I was able to do it via a join & union combination, but was wondering what is the most efficient way of doing it if there are more than 2 tables. Doesn't feel very streamlined to have multiple join & union combinations.
My data looks like this:

Thank you.