Иногда нужен просто чистый SQL.
public function findByCompany($company) { $em = $this->getEntityManager(); $connection = $em->getConnection(); $statement = $connection->prepare("SELECT a.id, a.responsible, a.company, b.sales_id, b.title FROM sales_activity AS b LEFT JOIN sales AS a ON ( a.id = b.sales_id ) WHERE a.company = :company"); $statement->bindValue('company', $company); $statement->execute(); $results = $statement->fetchAll(); return $results; }