So I'm stuck trying to figure out how to do this nested select in jOOQ 3:
Assuming two tables, A and B that have a 1 to many foreign key relationship
-
Table<ARecord> a1 = create.select(A.ID, max(A.SOME_DATE).as("max"))
.from(A).where(A.ID.in(1,2,3).asTable("a1");
create.selectFrom(B).where(B.SOME_DATE.ge(a1.field("max")));
This doesn't work because a1.field() has lost its type.
So how do implement this properly?
http://www.jooq.org/doc/3.0/manual/sql-building/table-expressions/nested-selects/
Pete
--
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.
