multiple table joins

Hi,

You actually can do multiple table Joins pretty easily. Similar to other MSSQL Queries, you would just format your [b]Query[/b] with your desired [b]Join[/b] criteria under [b]System > Integrations > Databases [/b]by right-clicking the Database, selecting Add Query, and inputting your Query in the respective box.

This was actually asked about before at this post [url=https://support.decisions.com/forum/topic28194-question-about-sql-joins.aspx]here[/url].

Additionally, if you need to keep the Entity Action association of two tables joined in a [b]Report[/b], you can use the [b]Override Action Context[/b] property under the [b]ACTIONS [/b]category of the [b]Properties [/b]tab in the [b]Report Viewer[/b].

This allows you to provide the desired [b]Context [/b]for a specified Field pertaining to the [b]Data Source[/b].

You can read more about it in our [url=https://documentation.decisions.com/v8/docs/report-properties#actions:~:text=Data Field column-,Actions,-Action]Report Properties[/url] document.

Hope this helps,

Have a good day!