title: Custom POJO with Left Join in jooQ
body: <p>I'm doing a left join of Table A and Table B and trying to fetch the results into a custom POJO which has fields from both Table A and Table B as follows:</p>
  
  <pre><code>List&lt;MyCustomPojo&gt; res = create.select()
                           .from(TABLE_A)
                           .leftJoin(TABLE_B)
                           .on(TABLE_A.MY_CODE.eq(TABLE_B.MY_CODE))
                           .fetchInto(MyCustomPojo.class);
  </code></pre>
  
  <p>It works fine for all the fields except for the field <em>myCode</em> the one on which these two tables are joined. For me the values for <em>myCode</em> were picked up from the right table, Table B, which is NULL for all of those records in Table A that do not have a corresponding entry in Table B. I would like to know how jooQ decides which field to map to POJO and if this behavior is documented anywhere.</p>
  
  <p>My goal is to fetch all the fields from Table A and Table B into the custom POJO such that <em>myCode</em> is picked up from the left table. I would appreciate your advice on the right way to achieve it.</p>