It was a silly question, I didn't realize that Person.ID was an instance field not a class field. It should be named Person.id. The code generator doesn't respect standard Java naming rules (with default settings), and led me to misunderstand the code.
Gérald Le vendredi 8 novembre 2013 16:59:54 UTC+1, [email protected] a écrit : > > Hello, > > I'd like to write something like > select > b.id,b.title, > a.id,a.name, > r.id,r.name > from book b > join person a on a.id=b.author_id > left join person r on r.id=b.reviewer_id > > I found the documentation > http://www.jooq.org/doc/3.2/manual/sql-building/table-expressions/aliased-tables/and > wrote > Book b = BOOK.as("b"); > Person a = PERSON.as("a"); > Person r = PERSON.as("r"); > create.select( > b.field("ID"),b.field("TITLE"), > a.field("ID"),a.field("NAME"), > r.field("ID"),r.field("NAME") > ).from(b) > .join(a).on(a.ID.equal(b.AUTHOR_ID)) > .leftJoin(r).on(r.ID.equal(b.REVIEWER_ID)) > > But then fields are not type safe, and column names are just strings. Is > it possible to write something like: > create.select( > b.id,b.title, > a.id,a.name, > r.id,r.name > ).from(b) > .join(a).on(a.ID.equal(b.AUTHOR_ID)) > .leftJoin(r).on(r.ID.equal(b.REVIEWER_ID)) > > Thanks, > Gérald > -- 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.
