$this->get('doctrine')
        ->getManager()
        ->createQueryBuilder()
        ->select('a.name as name')
        ->addSelect('b.code as code')
        ->from('alpha', 'a', 'b.code')
        ->innerJoin('beta', 'b', 'WITH', 'b.code = a.code')
        ->getQuery()
        ->getResult();