How to Do INNER JOINS in Hasura

[nevingeorgesunny]

I have added a remote scheme
in which I have some relationship (JOINS)

which while I execute the following query

{
  fetchTrack{
    data{
      id
      name
      entityPrice{
        data{
          pre_discount_price
        }
      }
    }
  }
}

Price and entityPrice and mapped with some relationship
this is a join

something like (select * from track t join on entityPrice ep on t.id = ep.entity_id)

when I query this data I get

{
  "data": {
    "fetchTrack": {
      "data": [
       
        {
          "id": "0180bd29-8d74-4c78-a084-5104311dc956",
          "name": "load testing track",
          "entityPrice": {
            "data": []
          }
        },
        {
          "id": "017fdc6e-a3da-436e-99c2-0c47ac5a51e2",
          "name": "Staging Valid Track",
          "entityPrice": {
            "data": [
              {
                "pre_discount_price": 200000
              }
            ]
          }
        }
      ]
    }
  }
}

As you can see the first element , the entity Price is empty

this means that this is a LEFT JOIN

is there any way to do an INNER JOIN instead

such that i will get the result as

{
  "data": {
    "fetchTrack": {
      "data": [
        {
          "id": "017fdc6e-a3da-436e-99c2-0c47ac5a51e2",
          "name": "Staging Valid Track",
          "entityPrice": {
            "data": [
              {
                "pre_discount_price": 200000
              }
            ]
          }
        }
      ]
    }
  }
}