Additional JOIN Clause in Data Model Properties.
|
|
Additional JOIN Clause in Data Model Properties.
|
If you do not want to explicitly add a table to a data model or it is impossible to define the relations with this table using the mechanism of simple relations, you can manually prepare an additional JOIN condition in the model properties. This condition will be included in the FOR clause of the query. Use the SQL syntax like:
[LEFT OUTER ] Join <#<table.DataSource>#> alias On alias.field1=alias1.field1 ...
To make reference to a table not in the model, use the construction <#<table_name.Data_Source>#>. For the tables of the model use their aliases only!