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