...
The same would apply if your chart had objects from ‘ukpostcode’ and ‘nr_customers’ but you also had ‘nr_sales’ as a category object; when the chart SQL was created initially it wouldn’t join to ‘nr_sales’ , but once a category object on the ‘nr_sales’ table had been selected that table would also be joined on the underlying chart SQL.
| Info |
|---|
Please refer to this page for more information on table priorities. |
Forcing a Join / Referencing Fields on Other Tables
...