title: How to translate an SQL statement to TypeORM query builder?
body: <p>How would I convert the code below to TypeORM querybuilder?
  I am trying to follow the <a href="https://github.com/typeorm/typeorm/blob/master/docs/select-query-builder.md#inner-and-left-joins" rel="nofollow noreferrer">documentation</a>.</p>
  <pre><code>this.repository.manager.query(`
      SELECT item.name, item.id
      FROM item_location
      INNER JOIN item ON item.id = item_location.itemId
      WHERE item_location.locationId = ${queryObject.filter};
  `)
  </code></pre>
  <p>Thanks.</p>