Inner join two database grafana

[ericalm]

I want to make an inner join of 2 tables, but one is in x database and the other in Y database, that is, they are 2 different databases, in sql I solve it easily as follows:

SELECT * FROM aoidata.produccion as aoi
INNER JOIN smtdatabase.orden_trabajo as smt
ON aoi.op=smt.op

How do I do this query in grafana? if you only let me select only 1 data sourc

[mattabrams]

@ericalm

if you only let me select only 1 data sourc

Are you saying that you have connected to a SQL database through grafana, but you can only query on of those? If so, you can add a second datasource of the same kind (say, MySQL) and then add two queries to the panel. After that, you could try merging the two tables using a transformation like the merge transform.

But maybe I misunderstand?

I would also search this forum for similar questions:

PostgreSQL INNER JOIN Query

Grafana v8.0.6 PostgreSQL 13 I am attempting to set up graphs from data contained in the DB tables using INNER JOIN. The query I have started with in pgAdmin 4 retrieves exactly what I am looking for. See snippet below. This is the query i am running in the query tool. Working PostgreSQL Query: SELECT tm.source, td.value, td.timestamp FROM trend_view td INNER JOIN trend_meta tm ON td.externallogid = tm.externallogid WHERE tm.source like ‘%PRTG%AC8%’ AND td.type = 0 ORDER BY tm.s…