Are you trying to do an inner join where you only pull back contacts who belong to a company?
Jeremy Burns Class Outfit [email protected] http://www.classoutfit.com On 15 Jun 2011, at 17:44, Zuha wrote: > Seems like this should be easy, and maybe I'm just missing how to do > it, but I want to execute the following query. [preferrably using > find('list')] > > SELECT `Contact`.`id`, `Contact`.`name` FROM `contacts` AS `Contact`, > `contact_companies` AS `ContactCompany` WHERE `Contact`.`id` = > `ContactCompany`.`contact_id` ORDER BY `Contact`.`name` ASC > > ContactCompany belongsTo Contact > > That query returns the exact information I want, but without query(), > I don't see how to do it. > > -- > 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 -- 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
