jOOQ can I fetch a join of two tables into the respective POJOs
<p>In jOOQ if I want to fetch a row of a table into a jOOQ autogenerated POJOs I do, for instance:</p>

<pre><code>dsl.selectFrom(USER)
                .where(USER.U_EMAIL.equal(email))
                .fetchOptionalInto(User.class);
</code></pre>

<p>Now, suppose that I want to do a join between two tables, e.g. <code>USER</code> and <code>ROLE</code>, how can I fetch the result into the POJOs for these two tables?</p>