Reservation hasOne User $this->Reservation->find('all') query: select Reservation left join User Reservation hasOne User Ressource hasMany Reservation $this->Ressource->find('all') queries: select Ressource select Reservation ! select User = 1 ! select User = 2 etc... expected queries: select Ressource select Reservation left join User