title: TypeORM QueryRunner Select distinct
body: <p>Below is my SQL query:</p>
  <pre><code>Select distinct ports.port_name from orders left join port_master on orders.officeId = ports.portId;
  </code></pre>
  <p>How to write the above SQL using typeorm query runner to select the distinct port name? Below syntax fetches all the ports</p>
  <pre><code>await queryRunner.manager.find(Orders, {
    relations: [&quot;ports&quot;],
    where: filter
  }).then((result: any) =&gt; {
    orders = result;
  });
  </code></pre>