Convert frame from rows error

Grafana Configuration
,
1

Hi i have this error as i have coded:

SELECT * FROM observation, camera;

and I’m getting this:

convert frame from rows error: duplicate column names are not allowed, found identical name “id” at column indices 0 and 9

2

Which back-end data store is this? It looks like MySQL or similar, in which
case what is the output from:

show create table observation;
show create table camera;

I strongly suspect that each table has a column named ‘id’ in it.

Perhaps try instead:

select observation.*,camera.* from observation,camera;

Antony.

3

Yes its MySQL database based on MariaDB and yes this is correct i have two columns called ID but in one (camera) column there is only id from 1 to 5 and in other (observation) column there’s multiple of them

although in Camera table i have columns
longitude
latitude
address
updatedat as time stamp
description
name
id
AND in Obsevration i have:
car
bus
etc.
updatedat as time stamp
cameraid
id
and i want to show on World Map Panel counts of Cars from Observation but show it by longitude and latitude
any ideas?
many thanks!!