Иногда нужен просто чистый 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;
}



