I need a way in CakePHP to find if a 1-Many record has more that that one entry in the Many Table...
This what what i would like to do in Cake... SELECT *, COUNT(`tank_id`) AS NumOccurrences FROM `shipments` LEFT JOIN `tanks` ON (`shipments`.`tank_id` = `tanks`.`id`) GROUP BY `tank_id` HAVING ( COUNT(`tank_id`) > 1 ) -- 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
