AnsweredAssumed Answered

Context for Self Join

Question asked by sccardais on Apr 27, 2016
Latest reply on Apr 29, 2016 by user19752

I have a data table - UTILIZATION - that holds utilization metrics for our software.

 

Each record holds utilization info about a specific customer.  We have multiple versions of our product so the version a customer is using is stored in a field, Version. A global field - g_version is formatted as a checkbox set which allows the Version field to hold more than one version of our product.

 

A self join TO  matches when the values in the base table::g_version = Join::version.

 

I want to find records that meet additional find criteria.

 

Should the layout / context be based on the base table,or the self join TO ?

 

When entering the search criteria, should I be searching fields in base table or the self join TO?

 

This is an on-going struggle to fully understand context. Thanks in advance for any and all help.

Outcomes