Create a Data Service Query to Join Multiple Inner Tables
Run queries which join multiple inner tables.
Example Multiple Inner Table Join
{ "name" : "TestQuery", "sinceDate" : "2001-01-01 17:30:00", "pageSize" : "500", "nextTableName" : null, "nextKey" : null, "tables" : [ { "tableName" : "TASK", "columns" : [ "TASK_ID", "TASK_NAME", "TASK_TYPE", "STATUS_CODE", "EARLY_START_DATE", "EARLY_END_DATE" ], "condition" : { "operator" : "AND", "conditions" : [ { "columnName" : "TARGET_WORK_QTY", "operator" : "GREATER_THAN_OR_EQUALS", "value1" : "40", "value2" : null }, { "columnName" : "TASK_ID", "operator" : "EQUALS", "value1" : "91813", "value2" : null } ] }, "joinedTables" : [ { "tableName" : "PROJECT", "columns" : ["PROJ_ID", "PROJ_SHORT_NAME"], "joinCondition" :{ "columnName1" : "TASK.PROJ_ID", "columnName2": "PROJECT.PROJ_ID" } },{ "tableName" : "TASKRSRC", "columns" : ["TASK_ID", "RSRC_ID"], "joinCondition" :{ "columnName1" : "TASK.TASK_ID", "columnName2": "TASKRSRC.TASK_ID" } } ] } ] }