Hi everyone!!!, I tried writing a join query with inner join. If I execute left and right queries individually, they are having the common transaction Ids but the whole query is not giving any output. Also, for the same query, If I give left as a table instead of query, it is giving valid output. Can someone please help me with this!!! { "dataSource": { "type": "join", "left": { "type": "query", "query": { "dataSource": { "type": "table", "name": "txn_Dev" }, "queryType": "groupBy", "intervals": [ "2024-02-15T150301.508Z/2025-02-22T150301.508Z" ], "granularity": "all", "virtualColumns": [], "filter": { "type": "and", "fields": [ { "type": "selector", "dimension": "tenantId", "value": "apitftrans1209" }, { "type": "selector", "dimension": "triggerState", "value": "COMPLETED" }, { "type": "in", "dimension": "gsiId", "values": [ "1209040733696" ] }, { "type": "in", "dimension": "triggerCuId", "values": [ "1205142740945" ] }, { "type": "selector", "dimension": "txnSlotItemDataName", "value": "phyent187654567" } ] }, "aggregations": [], "dimensions": [ "transactionId" ] } }, "right": { "type": "query", "query": { "dataSource": { "type": "table", "name": "txn_Dev" }, "queryType": "groupBy", "intervals": [ "2024-02-15T150301.508Z/2025-02-22T150301.508Z" ], "granularity": "all", "virtualColumns": [], "filter": { "type": "and", "fields": [ { "type": "selector", "dimension": "tenantId", "value": "apitftrans1209" }, { "type": "selector", "dimension": "triggerState", "value": "COMPLETED" }, { "type": "in", "dimension": "gsiId", "values": [ "1209040733696" ] }, { "type": "in", "dimension": "triggerCuId", "values": [ "1205142740945" ] }, { "type": "selector", "dimension": "txnSlotItemDataName", "value": "phyent29876545678" } ] }, "aggregations": [], "dimensions": [ "transactionId" ] } }, "rightPrefix": "r.", "condition": "transactionId == \"r.transactionId\"", "joinType": "INNER" }, "queryType": "scan", "intervals": [ "2024-02-14T111047.748Z/2025-02-21T111047.748Z" ], "granularity": "all", "virtualColumns": [], "columns": [ "transactionId" ] }