0

I generated the tables from django migrations. My elec_meter_machine table exists with the devEUI column
Here is my request.

SELECT AVG(r.voltage),AVG(r.current),m.devEUI FROM elec_meter_reporting r
INNER JOIN elec_meter_infosignal AS s
ON s.id=r.infos_signal_id
INNER JOIN elec_meter_machine AS m
ON m.devEUI = s.machine_id
WHERE m.devEUI="8cf9572000023509"

ERROR: ERROR: the m.deveui column does not exist
LINE 5: ON m.devEUI = s.machine_id
HINT: Maybe you want to reference the column "m.devEUI"
What am I not doing right?

a_horse_with_no_name
  • 497,550
  • 91
  • 775
  • 843
leauradmin
  • 133
  • 6

0 Answers0