Symfony combinate 2 queries
You can use a subquery as follow:
$sub = $this->createQueryBuilder('i2');$sub->select("max(i2.inv_date)");$sub->where("i.invExport= i2.invExport");$qb = $this ->createQueryBuilder('i') ->select('..., i.invDate') ... ->where('i.invDate = ( '.$sub->getDQL().' )'); ->andWhere('i.invExport = :export') ->setParameter('export', $export);
hope this help