How to get data from a table?

Question

JavaScript

Good afternoon, tell me how can I write a sql query and get data from table A using data from table B?
There are 2 tables in postgresQL of this type:
Table A

A

Table B

B

How can I fetch location data from table A using data from table B?
sensorid from table B is equal to id in table A
as I tried to solve but nothing happened

await app.ds.pg.query(`SELECT location, id FROM A WHERE id IN (${list.sensorid.join(",")}) GROUP BY location, id`);

Why didn't it work?
After all, I take the select and id columns from table A and extract data from them that are equal to id == sensorid and place them in a new table
, what is the error and how to do it right?

Answer 1

1. do you have apostrophes (or what is it?) instead of quotation marks?
2. the handler does not see the variable, it sees a line like

SELECT location, id FROM A WHERE id IN (${list.sensorid.join(",")}) GROUP BY location, id

need like this:

await app.ds.pg.query('SELECT location, id FROM A WHERE id IN (' + ${list.sensorid.join(',')} + ') GROUP BY location, id');