title: How can I select a column by name in jooq, when result record has two columns of different tables with the same name?
body: <p>I am using Jooq and as a result of a query with some joins I have a list of <a href="https://www.jooq.org/javadoc/latest/org.jooq/org/jooq/Record.html" rel="nofollow noreferrer">Record</a> .</p>
  <p>This record includes two columns with name &quot;id&quot; and I would need to select one of them.</p>
  <p>This <a href="https://www.jooq.org/javadoc/latest/org.jooq/org/jooq/Record.html#get(java.lang.String)" rel="nofollow noreferrer">method</a> has String as parameter and it is not failing when passing &quot;id&quot; (probably returning the first occurrence).</p>
  <p>The other alternative I saw is to use the <a href="https://www.jooq.org/javadoc/latest/org.jooq/org/jooq/Record.html#get(int)" rel="nofollow noreferrer">method</a> that receives an int with the index. This would work ok but I would prefer to avoid it.</p>