Thanks for your answers. I use CakePHP 1.1.7.3363 (I should upgrade to the last version).
The main problem in this case with the hasMany association is that it does a lot of requests, which are useless, everything I need can be done with only one. A profile can have many users. Here is a "UML-like" schema of my tables : |Profile|-[0,*]----[1,1]-|User|-[0,*]----[1,1]-|Post| And the (shortened) request I'd like to have : SELECT Post.*, User.*, Profile.* FROM Post LEFT JOIN User ON Post.userid = User.id LEFT JOIN Profile ON User.profileid = Profile.id SORT BY Profile.something --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Cake PHP" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cake-php -~----------~----~----~----~------~----~------~--~---
