admin管理员组

文章数量:1391969

I cannot success in merge 3 SQL queries in Grafana. My case:

  1. First query in datasource A mysql:

    id1 id2 metric
1   11  3445
2   52  4523

  2. 2nd query in datasource B mysql:

    id1 name
1   spain
2   france

  3. 3rd query in datasource B mysql:

    id2 name
11  madrid
52  paris

I want in the table join the 3 queries and have the id names with the metric:

id1 id1_name id2 id2_name metric
1   spain    11  madrid   3445
2   france   52  paris    4523

I have used the merge and join by field transformations, and impossible to make it. Only work with 2 queries, when I enable the third query doesn't work.

本文标签： Merge multiple SQL queries in GrafanaStack Overflow

版权声明：本文标题：Merge multiple SQL queries in Grafana - Stack Overflow 内容由网友自发贡献，该文观点仅代表作者本人， 转载请联系作者并注明出处：http://www.betaflare.com/web/1744702520a2620642.html， 本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌抄袭侵权/违法违规的内容，一经查实，本站将立刻删除。