I'm trying to create a hierarchy across two data sources. OR, if i can somehow link the tables together properly. I have two data sources. One has more records than the second. I'm only using the second to look up departments of people that are on the first. There are more people on the first data source so when I do a join, it removes those without a department listed in the second. How can I do a join that won't do that?
I was able to figure this out. I did a left join which kept all the records on the left side and only brought in data based on the criteria I set from the right.