JOIN queries not working in Node-postgres

Question

I'm trying to query two relational tables together using Node-PostgreSQL, but getting a syntax error:

    ;(async () => {
        const client = await pool.connect()
        try {
          const res = await client.query('SELECT * FROM "Booking" JOIN "User" ON "User.id"="Booking.renter"')
          console.table(res.rows)
        } finally {
          client.release()
        }
      })().catch(err => console.log(err.stack))

The Booking table and the User table is joined by the Booking.renter column and the User.id column, but above code shows:

error: column "User.id" does not exist

Querying a single table works fine:

   const res = await client.query('SELECT * FROM "Booking"')

Ed Bangga · Accepted Answer · 2019-12-10 02:30:38Z

3

You should wrap your table.column individually.

const res = await client.query('SELECT * FROM "Booking" JOIN "User" ON "User"."id"="Booking"."renter"')

answered Dec 10, 2019 at 2:30

Ed Bangga

13k4 gold badges18 silver badges31 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

JOIN queries not working in Node-postgres

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related