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"
					}
				}
			]
		}
	]
}