thanks man, as you described I was doing everything wrong, thank you! jooq
it's fantastic
Em quarta-feira, 20 de junho de 2018 10:25:37 UTC-3, Junior Manzini
escreveu:
>
>
> 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.
