Look in the CakePHP book at: http://book.cakephp.org/view/1017/Retrieving-Your-Data and browse through each section, so that you can find the examples for DISTINCT, grouping, OR, etc.
Complex find at: http://book.cakephp.org/view/1017/Retrieving-Your-Data#Complex-Find-Conditions-1030 as well as grouping described in: http://book.cakephp.org/view/1017/Retrieving-Your-Data#find-1018 Enjoy, John On May 11, 6:59 am, jthommo <jtho...@gmail.com> wrote: > Thanks Paul, > > I'll give it a go. > > You're right - the teknoid.wordpress.com site has a good bunch of > HABTM stuff on it, in > particular:http://teknoid.wordpress.com/2008/08/06/habtm-and-join-trickery-with-... > > I think what I'm really missing is more detail on the various > parameters you can stick into find(). In your example, you've used > DISTINCT and OR and in the linked-to article they use 'group'. Where > are these coming from? Am I missing this as I'm new to SQL in general? > The book isn't exactly detailed in this area... > > Thanks a lot, > Jeremy > [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