search

fac22 / week2-ABES

PostgreSQL Database project
1 stars 0 forks source link

Good use of the template literal plug for SQL #28

Open cemalokten opened 3 years ago

cemalokten commented 3 years ago

Like how you used the plugin along with /* SQL */ to increase readability

const queryStr = /* sql */ `
    SELECT
      place.place_name,
      place.postcode,
      place.rating,
      users.username,
      reviews.review
    FROM place
    LEFT JOIN reviews
      ON reviews.place_id = place.place_id
    LEFT JOIN users
      ON reviews.author_id = users.author_id
  `;