Create a Data Service Query to Join Two Tables
Run queries which join two tables specifying the columns on each side of the join.
Example Two 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" ], "joinedTables": [ { "tableName": "PROJECT", "columns": [ "PROJ_ID", "PROJ_SHORT_NAME" ], "joinCondition": { "columnName1": "TASK.PROJ_ID", "columnName2": "PROJECT.PROJ_ID" } } ] } ] }