gistfile1.txt

SELECT a.country_code,a.city,a.street from person p
Join  adress_data a
    on p.adress_data_id = a.id
JOIN country c
    on c.code=a.country_code where c.code="DE"
    
    
    My Symfony version: (not working):
    
    
            $queryBuilder = $this->createQueryBuilder("p")
            ->innerJoin("p.adressData", "a")
            ->innerJoin("a.country","c")
            ->where("c.code=:code")
            ->setParameter(':code', strtoupper($code));