...
This same functionality can also be used to force the ‘driving’ table, if a table has a lower number the SQL will drive off that table first, i.e., it will be placed first in the FROM clause.
| Info |
|---|
If you experience any issues with how your data is displaying, we advise checking that table priorities are not incrementing. By default, they should all be set to 999 and that means that one table will take priority over any of the others. |
Where Clause: This is an overarching WHERE clause that will be added to all SQL generated using this table. For example, if we don’t want to see any records where No Fraud has been found we could enter something like this.
...