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

Package org.datanucleus.store.mapped.expression

Class org.datanucleus.store.mapped.expression.QueryExpression

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

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.

            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

            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

                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

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.