#doctrine-query-builder

[scanf-info]

Doctrine Left Join Examples

If you want to join non-releated entities:

$qb = $this->_em->createQueryBuilder(); $qb->select('E'); $qb->from(Exam::class, 'E') ->join(TrainingSchema::class, 'TS', Join::WITH, 'TS.id = E.trainingSchema') ->where('1=1');

If have a relation between entites:

$qb = $this->_em->createQueryBuilder(); $qb->select('E'); $qb->from(Exam::class, 'E') ->join('E.trainingSchema', 'TS') ->where('1=1');

Second one, automatically detect relation on part.