Hello, I'm sorry for the delay. Somehow, your request got stuck in the Google Groups. The non-DSL syntax for left outer joins is this:
q.addJoin(T_BOOK, JoinType.LEFT_OUTER_JOIN, T_AUTHOR.ID.equal(T_BOOK.AUTHOR_ID)); See JoinType for more information: https://github.com/lukaseder/jOOQ/blob/master/jOOQ/src/main/java/org/jooq/JoinType.java Cheers Lukas 2012/1/29 Pay Liu <[email protected]>: > > In Non-DSL query, How to add a Left Outer Join? or not yet support ? > > Thanks! > > > SelectQuery q = create.selectQuery(); > q.addFrom(T_AUTHOR); > > q.addLeftOuterJoin(T_BOOK, T_AUTHOR.ID.equal(T_BOOK.AUTHOR_ID)); > > >
