void |
Select.addColumn(String source,
String name,
Alias alias) |
Add a single column to the select list, providing an alias for the column
|
SelectAdapter |
SelectAdapter.addColumn(String source,
String name,
Alias alias) |
|
SelectItemColumn |
SelectList.addColumn(String source,
String name,
Alias alias) |
|
void |
FromClause.addFrom(Select sub,
Alias alias) |
Add the sub-query as an item in the from list
|
void |
Select.addFrom(Select sub,
Alias alias) |
Add a sub-select statement with an alias to the from-clause
|
void |
FromClause.addInnerJoin(String tableName,
Alias alias,
ExpNode joinOnPredicate) |
Add an inner join clause to the FROM items list
|
void |
Select.addInnerJoin(String tableName,
Alias alias,
ExpNode joinOnPredicate) |
Add an inner join to the from clause for this select statement.
|
void |
FromClause.addLeftOuterJoin(String tableName,
Alias alias,
ExpNode joinOnPredicate) |
Add a left outer join clause to the FROM items list
|
void |
Select.addLeftOuterJoin(String tableName,
Alias alias,
ExpNode joinOnPredicate) |
Add a left outer join to the from clause for this select statement.
|
SelectItemSubQuery |
SelectList.addSubQuery(Select subQuery,
Alias alias) |
|
void |
FromClause.addTable(String tableName,
Alias alias) |
Add a table to the FROM items list
|
void |
FromClause.addTable(String schemaName,
String tableName,
Alias alias) |
Add a qualified schema.table with an alias.
|
void |
Select.addTable(String tableName,
Alias alias) |
Add a table item with an alias to the from-clause
|
void |
Select.addTable(String schemaName,
String tableName,
Alias alias) |
Add a schema-qualified table item with an alias to the from clause
|
FromAdapter |
FromAdapter.from(String tableName,
Alias alias) |
Add a table with an alias (tab AS foo) to the from clause
returning this FromAdapter ready for the next item
|
FromAdapter |
SelectAdapter.from(Select sub,
Alias alias) |
Add the sub-query select to the FROM clause
|
FromAdapter |
SelectAdapter.from(String tableName,
Alias alias) |
Create a from clause for this select statement
|
FromAdapter |
FromAdapter.innerJoin(String tableName,
Alias alias,
WhereFragment joinOnPredicate) |
Add an INNER JOIN for the given table
|
FromAdapter |
FromAdapter.leftOuterJoin(String tableName,
Alias alias,
WhereFragment joinOnPredicate) |
Add a LEFT OUTER JOIN for the given table
|
void |
SelectItem.setAlias(Alias alias) |
|