Hello, I'm not quite sure what you're trying to do. Nesting joins I suppose? Can you express the SQL statement that you're trying to create, and we'll see how it can be translated to the jOOQ API
Cheers Lukas 2013/8/30 <[email protected]> > I have 2 Tables both the same column name, id. However, these column names > do not have any foreign key relationship. > > Table A: > id, > other, > stuff > > Table B: > id, > more, > things > > I use the join of both these tables and alias it so I can do a semi join. > A.join(B).asTable("inner"); > A.join(B).asTable("outer"); > > I would like to use both id columns, however when I use inner.getField( > A.ID) and inner.getField(B.ID), they both go to same aliased field > inner.id > > How can I change the B.ID column of the joined table to have a different > alias? > > -- > You received this message because you are subscribed to the Google Groups > "jOOQ User Group" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > For more options, visit https://groups.google.com/groups/opt_out. > -- You received this message because you are subscribed to the Google Groups "jOOQ User Group" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/groups/opt_out.
