Can't inner join more than 2 queries

Grafana
1
  • What Grafana version and what operating system are you using?

Grafana v9.5.21 (2dd6ebef03fbe42927769bf00bcf0bc4e621bb9c)

  • What are you trying to achieve?

I need to inner join three tables:

Table A
a_id | name

Table B
b_id | a_id | price

Table C
c_id | b_id | owner
  • How are you trying to achieve it?
  1. Add a Join by field transformation
  2. Select the INNER Mode for the transformation
  3. Select the a_id value
  4. Add one more Join by field transformation
  5. Select the INNER Mode for the transformation
  6. Select the b_id value
  • What happened?

There is no owner column in the result table.

  • What did you expect to happen?

A table that looks similarly to the following:

Result Table
a_id | name | b_id | price | c_id | owner
  • Can you copy/paste the configuration(s) that you are having problems with?

No

  • Did you receive any errors in the Grafana UI or in related logs? If so, please tell us exactly what they were.

No, did not receive.

  • Did you follow any online instructions? If so, what is the URL?