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.