SOLVED: I used Factory.fieldByName method:
> Factory create=new Factory(CDatabaseManager.dbConnection(),
> SQLDialect.MYSQL);
>
> Result<Record>r=create.select(Factory.fieldByName("ha_mmContent", "Name"),
> Factory.fieldByName("ha_mmExt", "ExtName"),
> Factory.fieldByName("ha_mmTypes", "TypeName")).
> 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();
>
On Friday, November 2, 2012 12:42:06 PM UTC+1, Marko Frelih wrote:
>
> 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
>
