Dear Sirs and Madams!
I am newbie at jooq and in my project I've bypassed code generation of my
db schema and I have following statement, which works perfectly:
> Factory create=new Factory(CDatabaseManager.dbConnection(),
> SQLDialect.MYSQL);
> Result<Record> r=create.select().from("ha_mmContent").
> join("ha_mmLinkTable").on("ha_mmContent.ID=ha_mmLinkTable.IDContent").
> join("ha_mmExt").on("ha_mmLinkTable.IDExtension=ha_mmExt.ID").
> join("ha_mmTypes").on("ha_mmLinkTable.IDType=ha_mmTypes.ID").
> where("ha_mmContent.isActive=1").fetch();
> for(int iIndex=0; iIndex<r.size(); iIndex++)
> {
> System.out.println(iIndex);
> //results.add(r.getValuesAsString(iIndex).toString());
> } // for
>
Now, the upper select gets me all fields of joined tables. How do I
specify in .select() part of statement, which fields to retreive?
Sincerely,
Marko
