Hmmm... I don't have my work machine handy, but have you tried something like:
select().from(TABLE) .where(a1.equal(b1).or(a2.equal(b2)).or(a3.equal(b3))) .and(c1.equal(d1).or(c2.equal(d2).or(c3.equal(d3)))) If you add the logical operator directly after the comparison, it'll nest it. The last example should help http://www.jooq.org/manual/DSL/CONDITION/ Hope that fixes your issue :) On Thursday, June 28, 2012 6:45:24 PM UTC-4, [email protected] wrote: > > Hi i am trying to figure out how to write something like this in jooq > > Code: > > select * from table where ( ( a = query or b = query or a = query ) and ( e = > query or g = query or z = query) ) > > I cant figure out how to do nested condition in jooq. Please help
