Using Implicit Joins
Run queries using joins to retrieve data from two related tables.
Example Query With an Implicit Join to a Single Inner Table
{ "name": "Project Activites", "pageSize": "1000", "tables": [ { "tableName": "TASK", "columns": [ "TASK_ID", "PROJ_ID", "WBS_ID", "TASK_TYPE" ], "joinedTables": [ { "tableName": "PROJECT", "columns": ["PROJ_SHORT_NAME"] } ] } ] }
Example Query With Implicit Joins of Multiple Inner Tables
{ "name": "Test", "pageSize": "1000", "tables": [ { "tableName": "TASK", "columns": [ "TASK_ID", "PROJ_ID", "WBS_ID", "TASK_TYPE" ], "joinedTables": [ {"tableName": "PROJECT", "columns": ["PROJ_SHORT_NAME"] }, {"tableName": "PROJWBS", "columns": ["WBS_NAME"] }, {"tableName": "CALENDAR", "columns": ["CLNDR_NAME"] } ] } ] }
The incorrect use of implicit joins will fail to fetch data. In the example below there is no implicit join specified between the TASK and TASKRSRC tables.
Example of a Failed Implicit Join
{ "name": "Test", "pageSize": "1000", "tables": [ { "tableName": "TASK", "columns": [ "TASK_ID", "PROJ_ID", "WBS_ID", "TASK_TYPE" ], "joinedTables": [ {"tableName": "TASKRSRC", "columns": ["TASKRSRC_ID"] } ] } ] }