How to add data from table A to table B postgreSQL?

Question

PostgreSQL

I have 2 tables:
sensor_instances table

spoiler

and sensor_alerts table

spoiler

I can't figure out how to make an SQL query to get the sensor_alerts table with the addition of the location column from sensor_instances to it?
and it is necessary that locations be assigned to the lines sensor_alerts.sensorid = sensor_instances.id
tried such an entry, but in the end I get only location

SELECT location FROM sensor_instances LEFT JOIN sensor_alerts ON sensor_instances.id = sensor_alerts.sensorid

Answer 1

SELECT sensor_alerts.*, sensor_instances.location 
FROM sensor_instances 
  LEFT JOIN sensor_alerts ON sensor_instances.id = sensor_alerts.sensorid

first 20 lines

LIMIT and OFFSET or FETCH .