I recomend you to take a look at the CakePHP book at: http://book.cakephp.org/view/872/Joining-tables which will help you to implement my modified version of the SQL statement. Take a look, and show us your solution or any issues you may then have. Enjoy, John
On Mar 30, 3:09 am, Ryan <ryan.ravennasoluti...@gmail.com> wrote: > Thanks for the reply. > > I'm sure I can make it work with an SQL query, but I'm new to Cake and > I'm trying to work within the system :) > > Is there a way to make this complex a query work with conditions on > find(), paginate(), etc, or will I need to resort to writing custom > queries? > > ~Ryan > [snip] Check out the new CakePHP Questions site http://cakeqs.org and help others with their CakePHP related questions. You received this message because you are subscribed to the Google Groups "CakePHP" group. To post to this group, send email to cake-php@googlegroups.com To unsubscribe from this group, send email to cake-php+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php?hl=en To unsubscribe from this group, send email to cake-php+unsubscribegooglegroups.com or reply to this email with the words "REMOVE ME" as the subject.
