Examples of org.apache.ws.jaxme.sqls.SelectTableReference.leftOuterJoin()

Class org.apache.ws.jaxme.sqls.SelectTableReference

Examples of org.apache.ws.jaxme.sqls.SelectTableReference.leftOuterJoin()

org.apache.ws.jaxme.sqls.SelectTableReference.leftOuterJoin()

Indicates that the referenced table shall be joined in a left outer join with the given table pTable and returns a reference to that table.

    public void testLeftOuterJoin() {
        Table table = getPrimaryKeyTable();
        Table otherTable = getForeignKeyTable(table);
        SelectStatement statement = otherTable.getSelectStatement();
        SelectTableReference tableReference = statement.getSelectTableReference();
        JoinReference joinReference = tableReference.leftOuterJoin(table);
        
        TableReference refLocal = tableReference;
        TableReference refRef = tableReference.getRightJoinedTableReference();
        
        joinReference.getOn().addJoin((ForeignKey) otherTable.getForeignKeys().next(),

View Full Code Here

    public void testLeftOuterJoin() {
        Table table = getPrimaryKeyTable();
        Table otherTable = getForeignKeyTable(table);
        SelectStatement statement = otherTable.getSelectStatement();
        SelectTableReference tableReference = statement.getSelectTableReference();
        JoinReference joinReference = tableReference.leftOuterJoin(table);
        
        TableReference refLocal = tableReference;
        TableReference refRef = tableReference.getRightJoinedTableReference();
        
        joinReference.getOn().addJoin((ForeignKey) otherTable.getForeignKeys().next(),

View Full Code Here

  public void testLeftOuterJoin() {
     Table table = getPrimaryKeyTable();
     Table otherTable = getForeignKeyTable(table);
     SelectStatement statement = otherTable.getSelectStatement();
     SelectTableReference tableReference = statement.getSelectTableReference();
     JoinReference joinReference = tableReference.leftOuterJoin(table);


     TableReference refLocal = tableReference;
     TableReference refRef = tableReference.getRightJoinedTableReference();


     joinReference.getOn().addJoin((ForeignKey) otherTable.getForeignKeys().next(),

View Full Code Here

TOP

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.