Direct Connect Relationships between multiple sources, resulting in an incorrect query

Here is the general layout of the case for which the issue is arising. We have a simple report based on a data source of two tables: “Supplier” is a simple list of companies and “SupplierAlias” is a...