CODEWITHSUNDEEP
symfonydoctrine-orm
user2268997
user2268997

Reputation: 1391

Doctrine2 - Joining Entities without Associations Using ORM QueryBuilder

Is it possible to generate the query for Joining unassociated Entities using the ORM QueryBuilder as in : 

$query = $em->createQuery('SELECT u FROM User u JOIN Blacklist b WITH u.email = b.email');

Upvotes: 2

Views: 6492

Answers (1)

Jason Roman
Jason Roman

Reputation: 8276

I don't see why not...the QueryBuilder just converts down to DQL anyway.

http://doctrine-orm.readthedocs.org/en/latest/reference/query-builder.html

$qb = $em->createQueryBuilder()
    ->select('u')
    ->from('User', 'u')
    ->join('Blacklist', 'b', 'WITH', 'u.email = b.email')
;

Upvotes: 8

Related Questions