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.










