title: query multiple tables with knex.js
body: <p>I want to render with <code>Expres.js</code> and <code>knex.js</code> two tables using for that only one get function in order to use the data from both tables in one HTML template. It works when I query only one table (schools or students) but I don't know how to do with two tables.
  Any suggestion?</p>
  
  <pre><code>app.get('/schools', function(req, res) {
  
      knex.select()
      .from('schools', 'students')
      .then(function(schools, students) {
          res.render('schools', {
              schools: schools,
              students: students
          });
      }).catch(function(error) {
          console.log(error);
      });
  });
  </code></pre>