List of innerJoin() Examples

Examples of innerJoin()

com.mysema.query.jpa.JPQLQuery.innerJoin()
com.mysema.query.jpa.hibernate.HibernateQuery.innerJoin()
org.datanucleus.store.mapped.expression.QueryExpression.innerJoin()
Method to do an inner 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 @param equals if the join is applied as filter, if use equals or not equals @param unionQueries whether to apply the inner join in all queries unified by the union clause
org.datanucleus.store.rdbms.sql.SQLStatement.innerJoin()
Method to form an inner 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.innerJoin()
Method to do an inner 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 @param equals if the join is applied as filter, if use equals or not equals @param unionQueries whether to apply the inner join in all queries unified by the union clause

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

            // Add inner join to the container table
            DatastoreClass sourceTable = storeMgr.getDatastoreClass(elementType, clr);
            ScalarExpression sourceExpr = sourceTable.getIDMapping().newScalarExpression(stmt, stmt.getMainTableExpression());
            LogicSetExpression teTargetElement = stmt.newTableExpression(containerTable, valueIdentifier);
            ScalarExpression targetExpr = elementMapping.newScalarExpression(stmt, teTargetElement);
            stmt.innerJoin(sourceExpr, targetExpr, teTargetElement, true);
        }
        else
        {
            // Join to key table if this is join table, or value table
            boolean sourceJoin = (mapType == MAP_TYPE_JOIN || mapType == MAP_TYPE_KEY_IN_VALUE);

View Full Code Here

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

            // Add inner join to the container table
            DatastoreClass sourceTable = storeMgr.getDatastoreClass(elementType, clr);
            ScalarExpression sourceExpr = sourceTable.getIDMapping().newScalarExpression(stmt, stmt.getMainTableExpression());
            LogicSetExpression teTargetElement = stmt.newTableExpression(containerTable, valueIdentifier);
            ScalarExpression targetExpr = elementMapping.newScalarExpression(stmt, teTargetElement);
            stmt.innerJoin(sourceExpr, targetExpr, teTargetElement, true);
        }
        else
        {
            stmt = new UnionIteratorStatement(clr, elementCls, true, this.storeMgr,
                elementCls, elementMapping, containerTable, false, null,

View Full Code Here

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

            // Inner Join from the ID of the element to the element mapping of the join table
            JavaTypeMapping elementTableID = candidateTable.getIDMapping();
            ScalarExpression elmSetExpr = elementMapping.newScalarExpression(stmt,
                stmt.getTableExpression(setTableAlias));
            ScalarExpression elmExpr = elementTableID.newScalarExpression(stmt, elementTblExpr);
            stmt.innerJoin(elmExpr, elmSetExpr, elementTblExpr, true, true);


            // Select the ID of the element table
            stmt.selectScalarExpression(elementTableID.newScalarExpression(stmt, elementTblExpr));
        }

View Full Code Here

0 1 2

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.