Hello i need to select and join/union data from multiple My SQL database tables.
Databases are pr month and have the the same structure.
When selecting from one database i use this query:
> SELECT > $__timeGroupAlias(last_time,30m), > destination AS metric, > value AS "Batteri 1 tur" > FROM eib_tele_2020_08 > WHERE > destination = '0/4/0' > GROUP BY 1,2 > ORDER BY $__timeGroup(last_time,5m)
I would like show data from may(eib_tele_2020_05),june(eib_tele_2020_06) and july (eib_tele_2020_07) in the same graph.
Can someone help me out with an example?