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?