Left join with Pagerfanta Doctrine

2019-07-26 09:46发布

I'd like show results of two tables but I have this Exception: "Cannot count query which selects two FROM components, cannot make distinction".

My query is:

      $queryBuilder = $em->createQueryBuilder()
     ->select('e, e.id AS id, e.f14010101 AS f14010101, e.f14010105 AS f14010105')
     ->from('T140101Bundle\Entity\T140101', 'e')
     ->leftJoin('T140102Bundle\Entity\T140102', 'c', 'WITH', 'c.f14010201= e.id')
     ->groupBy('e.id');

Can you help me?

0条回答
登录 后发表回答