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?