doctrine / orm

     *

     * @return self

     */

    public function innerJoin($join, $alias, $conditionType = null, $condition = null, $indexBy = null)

    {

        $parentAlias = substr($join, 0, strpos($join, '.'));

        $rootAlias = $this->findRootAlias($alias, $parentAlias);

        $join = new Expr\Join(

            Expr\Join::INNER_JOIN, $join, $alias, $conditionType, $condition, $indexBy

        );

        return $this->add('join', [$rootAlias => $join], true);

    }

    /**

     * Creates and adds a left join over an entity association to the query.

     *

     * @return self

     */

    public function leftJoin($join, $alias, $conditionType = null, $condition = null, $indexBy = null)

    {

        $parentAlias = substr($join, 0, strpos($join, '.'));

        $rootAlias = $this->findRootAlias($alias, $parentAlias);

        $join = new Expr\Join(

            Expr\Join::LEFT_JOIN, $join, $alias, $conditionType, $condition, $indexBy

        );

        return $this->add('join', [$rootAlias => $join], true);

    }

    /**

     * Sets a new value for a field in a bulk update query.