Humm.. you can iterate over your $query array and set the MessageStatus.name manually. Something like this: http://pastie.org/private/ugpkirmaw6jevodpbudfw
It's just a suggestion, I think you may test the cost of this extra iteration and the extra join (and extra table) to choose that best fit your needs. You can check the Set core library and see if it already has some function to do this 'merge' logic too. HTH LipeDjow -- Our newest site for the community: CakePHP Video Tutorials http://tv.cakephp.org Check out the new CakePHP Questions site http://ask.cakephp.org and help others with their CakePHP related questions. To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/cake-php
