Hi im new here and i don’t have much experience with SQL so I run into a problem as i want to show data on Word Map Panel but every time i run into a problem as I’m using HeidiSQL as my database and i want to show on World Map Panel data from a table called observation but the latitude and longitude columns are in a different table called camera.
This is the code that worked when I’ve added one column with data
ORDER BY updatedat
I have tried using UNION and OUTER JOIN but that wasn’t working.
welcome to the forum, @lolz8922
this is a little tough for the community to understand. I would suggest first reading the docs on MySQL + Grafana and then, if you still need help, inspecting your panel and sharing your raw, unformatted data:
I have read that a bit, but the problem is that i have data source connected which is MySQL, and on World Map Panel i want to show data so i do query for example:
latitude = 0.000000
GROUP BY 1
ORDER BY $__timeGroup(updatedat,$__interval)
BUT in FROM section i need to choose another “table” for example:
FROM camera, observation
In both Camera and Observation i have columns called same.