When defining a JOIN in my SELECT query, how can I specify its alias name. I need this to resolve ambiguity later in the query when I have two joins to the same table.
Now I'm doing this: step.leftOuterJoin(tableName + " AS " + aliasName).on(condition); But I would like to use a Table<Record> instead of that table name string, via the new Factory.tableByName() method. -- Murray Cumming [email protected] www.murrayc.com www.openismus.com
