How to select multiple tables

Grafana MySQL
1

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?

2

I had ORDER BY $__timeGroup(last_time,5m) at the end of my UNION, this was giving me the problems.
This worked:

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

UNION

SELECT $__timeGroupAlias(last_time,30m), destination AS metric, value AS “Batteri 1 tur”
FROM eib_tele_2020_07
WHERE destination = ‘0/4/0’
GROUP BY 1,2

If anyone have simpler/better querry im wide open for suggestions :slight_smile: