List of leftOuterJoin() Examples

Examples of 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.
org.datanucleus.store.mapped.expression.QueryExpression.leftOuterJoin()
Method to do a left outer join to another table, and optionally apply it to any unions for this query. @param expr the left hand expression @param expr2 the right hand expression @param tblExpr The table expression for the table to apply the join @param equals if the join is applied as filter, if use equals or not equals @param unionQueries Whether to apply to unions of this query.
org.datanucleus.store.rdbms.sql.SQLStatement.leftOuterJoin()
Method to form a left outer join to the specified table using the provided mappings. Will be applied to all unioned statements. @param sourceTable SQLTable for the source (null implies primaryTable) @param sourceMapping Mapping in this table to join from @param target Table to join to @param targetAlias Alias for the target table (if known) @param targetMapping Mapping in the other table to join to (also defines the table to join to) @param discrimValues Any discriminator values to apply for the joined table (null if not) @param tableGrpName Name of the table group for the target (null implies a new group) @return SQLTable for the target
org.jpox.store.mapped.expression.QueryExpression.leftOuterJoin()
Method to do a left outer join to another table, and optionally apply it to any unions for this query. @param expr the left hand expression @param expr2 the right hand expression @param tblExpr The table expression for the table to apply the join @param equals if the join is applied as filter, if use equals or not equals @param unionQueries Whether to apply to unions of this query.

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

    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

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

    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

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

  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

Examples of org.datanucleus.store.mapped.expression.QueryExpression.leftOuterJoin()

            LogicSetExpression candidateTableExpression = stmt.newTableExpression(candidateTable, candidateTableIdentifier);
            ScalarExpression candidateExpression = candidateTable.getIDMapping().newScalarExpression(stmt, candidateTableExpression);
            if (allowNulls)
            {
                // Do LEFT OUTER JOIN since we need to allow nulls in the results
                stmt.leftOuterJoin(selectExpression, candidateExpression, candidateTableExpression, true);
            }
            else
            {
                // Do INNER JOIN since we don't allow nulls in the results
                stmt.innerJoin(selectExpression, candidateExpression, candidateTableExpression, true);

View Full Code Here

Examples of org.datanucleus.store.mapped.expression.QueryExpression.leftOuterJoin()

            ScalarExpression sourceExpr = sourceMapping.newScalarExpression(stmt, stmt.getMainTableExpression());
            ScalarExpression rootElementExpr = 
                candidateTable.getIDMapping().newScalarExpression(stmt, rootElementTblExpr);
            if (allowNull)
            {
                stmt.leftOuterJoin(sourceExpr, rootElementExpr, rootElementTblExpr, true);
            }
            else
            {
                stmt.innerJoin(sourceExpr, rootElementExpr, rootElementTblExpr, true);
            }

View Full Code Here

Examples of org.datanucleus.store.mapped.expression.QueryExpression.leftOuterJoin()

                LogicSetExpression tgtElementTblExpr = stmt.newTableExpression(targetElementTable, tgtElementTblId);
                ScalarExpression targetExpr =
                    targetElementTable.getIDMapping().newScalarExpression(stmt, tgtElementTblExpr);
                if (allowNull)
                {
                    stmt.leftOuterJoin(rootElementExpr, targetExpr, tgtElementTblExpr, true);
                }
                else
                {
                    stmt.innerJoin(rootElementExpr, targetExpr, tgtElementTblExpr, true);
                }

View Full Code Here

Examples of org.datanucleus.store.rdbms.sql.SQLStatement.leftOuterJoin()

            sqlStmt.setClassLoaderResolver(clr);


            if (vmd != null)
            {
                // Left outer join to value table (so we allow for null values)
                SQLTable valueSqlTbl = sqlStmt.leftOuterJoin(sqlStmt.getPrimaryTable(), valueMapping,
                    valueTable, null, valueTable.getIdMapping(), null, null);


                // Select the value field(s)
                SQLStatementHelper.selectFetchPlanOfSourceClassInStatement(sqlStmt, getMappingDef,
                    ownerSM.getExecutionContext().getFetchPlan(), valueSqlTbl, vmd, 0);

View Full Code Here

Examples of org.jpox.store.mapped.expression.QueryExpression.leftOuterJoin()

            LogicSetExpression candidateTableExpression = stmt.newTableExpression(candidateTable, candidateTableIdentifier);
            ScalarExpression candidateExpression = candidateTable.getIDMapping().newScalarExpression(stmt, candidateTableExpression);
            if (allowNulls)
            {
                // Do LEFT OUTER JOIN since we need to allow nulls in the results
                stmt.leftOuterJoin(selectExpression, candidateExpression, candidateTableExpression, true);
            }
            else
            {
                // Do INNER JOIN since we don't allow nulls in the results
                stmt.innerJoin(selectExpression, candidateExpression, candidateTableExpression, true);

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.