Hello everyone, I am totally newbie with jooq ... what I have done so far
was just to search in a simple way but now reproduce this search and it is
not working the way I am doing: Here's the research:
myQuery.Sql.add('FROM Course INNER JOIN (Person INNER JOIN Matric ON
Person.lNum = Matric.lPerson) ON Course.lNum = Matric.lCurso ');
myQuery.Sql.add('WHERE Course.lPeriodoLet >= ' + getSPL);
//This is the way I did, but there is an error
Result<?> result = ctx.select()
.from(COURSE)
.innerJoin("INNER JOIN (Person INNER JOIN Matric) ON
(Person.lNum = Matric.lPerson)")
.on("COURSE.LNUM=MATRIC.LCURSO")
.where("COURSE.lperiodoLet>=2017")
.fetch();
--
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/d/optout.
