LEFT OUTER MANY TO ONE JOIN in SQLScript

1238 Views Last edit Aug 10, 2017 at 02:06 AM 2 rev

Good morning,

I created a user-defined table function to pull together customer data used in my organization that contains 20+ left outer many to one joins to pull in various text fields.

This table function is then used as the foundation of a dimension view I call dimCustomer.

I've noticed that when I specify left many to one join instead of just left join, that join gets trimmed if the SQL query based off of the dimension view doesn't require it.
When I pull just customer number, the only table used is KNA1 despite all of these joins.

Recently I made a change to the function to pull in Sales Organization Texts via KNVV and TVKO, however, now the function always performs the join to TVKO despite the many to one syntax.

Am I doing something wrong here?
Do I need to do something else to get this join to be trimmed?