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.