Send the result of two Mysql tables to a view (ejs)

Question

I am working with Ejs and Node.JS with Mysql. I need to move to a two table info calculation view, but I am facing this error:

app.get("/calc", (req, res)=>{
    Palpite.findAll().then(calc =>{
        res.render("calc/index", {calc: calc})
    }).then(()=>{
        RPalpite.findAll().then(rp =>{
            res.render("calc/index", {rp: rp})
        })
    })
})

Error:

Referenceerror: Rp is not defined

<% rp.forEach(rpal=>{ %>
  <tr>
      <th scope="row"><%= rpal.id %></th>
      <th scope="row"><%= rpal.rp1 %></th>
      <th scope="row"><%= rpal.rp2 %></th>
      <th scope="row"><%= rpal.rp3 %></th>
      <th scope="row"><%= rpal.rp4 %></th>
      <th scope="row"><%= rpal.rp5 %></th>
  </tr>
<% }) %>

Answer 1

From what I understand, you want to add the two information in the template.

Here is an example of how it can be done:

app.get("/calc", (req, res)=>{
    Palpite.findAll().then(calc =>{
        req.calc = calc
    }).then(()=>{
        RPalpite.findAll().then(rp =>{
            res.render("calc/index", {rp: rp, rpal: req.calc })
        })
    })
})