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

[john landers]

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));