title: TypeOrm - NestJS using queryBuilder
body: <p>I have this db schema in mysql:</p>
  <pre><code>     users_tbl
       --------------------------------------------
       id        |  first_name         | last_name
       --------------------------------------------
       1         |  Jon                | Doe
       2         |  Mark               | Smith
  
  
       address_tbl
       ------------------------------------------------------------
       id        |  address            | city             | user_id
       ------------------------------------------------------------
       1         |  some address       | some city        | 1
  </code></pre>
  <p>Then, I wanted to use TypeOrm's queryBuilder inorder to get the address of Jon Doe.</p>
  <p>My raw sql query:
  <code>SELECT users.first_name, users.last_name, address.address, address.city FROM users INNER JOIN address ON address.user_id=users.id</code></p>
  <p>My TypeOrm queryBuilder:</p>
  <pre><code>const users = await this.userRepo
        .createQueryBuilder('users')
        .select('users.first_name', 'fName')
        .addSelect('users.last_name', 'lName')
        .addSelect('adr.address', 'address')
        .addSelect('adr.city', 'city')
        .innerJoin('address', 'adr', 'adr.user_id=users.id')
        .getMany();
  return users;
  </code></pre>
  <p>There doesn't seem to have any error as I am able to run a <code>GET</code> request. However, it returns an empty object. In my console, NestJS (or TypeORM) logs the generated mysql query. Here it is:</p>
  <p><code>SELECT adr.city AS city, adr.country AS country, adr.id AS adr_id, users.first_name AS fName, users.last_name AS lName FROM users users INNER JOIN address adr ON adr.user_id = users.id</code></p>
  <p>I copied and pasted it to perform a manual query in phpmyadmin. And the query seems to work, and gives me the expected output. Am I missing something in my code, or is this some TypeORM limitation?</p>