--- title: "Queries with joins" slug: "queries-with-joins" tags: ["Reference", "ePO 5.10.x", "ePO 5.10.0", "ePolicy Orchestrator – On-prem"] updated: 2026-08-26T07:18:15Z published: 2026-09-07T17:35:59Z canonical: "docs.trellix.com/queries-with-joins" --- > ## Documentation Index > Fetch the complete documentation index at: https://docs.trellix.com/llms.txt > Use this file to discover all available pages before exploring further. # Queries with joins You can use joins to display information from two or more tables. These joins are handled automatically. To use the join functionality, specify the tables (`targets`) and the columns from those tables that you want in the `core.executeQuery` `select` parameter. The underlying query system computes the necessary join criteria transparently and displays the correct results. > [!NOTE] > Note > > An error appears if there is no join information registered for the tables when the query runs. You can use the `core.listTables` command to determine which tables are related and are capable of participating in joins. The `relatedTables` table property contains this join information. ### Example query with a join This example executes a simple join between the `OrionTaskLogTask` and `OrionTaskLogMessage` tables. ``` URL: https://servername:port/remote/core.executeQuery?target=OrionTaskLogTaskMessage&select=(select OrionTaskLogTask.Name OrionTaskLogTaskMessage.Message )&joinTables=OrionTaskLogTask Python: mc.core.executeQuery(target="OrionTaskLogTaskMessage", select="(select OrionTaskLogTask.Name OrionTaskLogTaskMessage.Message )", joinTables="OrionTaskLogTask") OK: Name: New Task Message: Purge audit log Name: New Task Message: Purge audit log (Purge log records older than: 1 days) ```