Create a Data Service Query to Join a Single Inner Table with Multiple Conditions
Run queries which join a single inner table with multiple conditions.
Example Single Inner Table Join with Multiple Conditions
{ "name": "TestQuery", "sinceDate": "2001-01-01 17:30:00", "pageSize": "500", "nextTableName": null, "nextKey": null, "tables": [ { "tableName": "RSRCHOUR", "columns": [ "RSRC_HR_ID", "RSRC_ID", "TS_ID", "PROJ_ID" ], "joinedTables": [ { "tableName": "TIMESHT", "columns": [ "TS_ID", "RSRC_ID", "CREATE_USER" ], "joinCondition": { "operator": "AND", "joinConditions": [ { "columnName1": "RSRCHOUR.RSRC_ID", "columnName2": "TIMESHT.RSRC_ID" }, { "columnName1": "RSRCHOUR.TS_ID", "columnName2": "TIMESHT.TS_ID" } ] } } ] } ] }