Re: Using Aliased tables doesn't seem to match foreign keys.

[Lukas Eder]

Thanks for reporting this. This will be fixed as #1460:
https://sourceforge.net/apps/trac/jooq/ticket/1460

Cheers
Lukas

2012/5/26 john landers <jcl...@gmail.com>:
> Assuming there is a only one fkey defined between Book and Author.
> Example:
>
> This works:
> Select<Record> select = factory.select()
>                                .from(T_BOOK)
>                                .leftOuterJoin(T_AUTHOR)
>                                
> .onKey(T_AUTHOR.getReferencesTo(T_BOOK).get(0));
>
> But this doesn't:
>
> TBook book = T_BOOK.as("T1");
> TAuthor author = T_AUTHOR.as("T2");
>
> Select<Record> select = factory.select()
>                                .from(T1)
>                                .leftOuterJoin(T2)
>                                .onKey(T2.getReferencesTo(T1).get(0));
>