You're right! Thanks for reminding me of this. After reading the book I
ended up with
$options = array(
> 'fields' => array('id', 'name', 'goal', 'SUM(Registration.credits) AS
> slot_count'),
> 'contain' => false,
> 'joins' => array( array(
> 'table' => 'registrations',
> 'alias' => 'Registration',
> 'type' => 'LEFT',
> 'conditions' => array(
> 'Account.id = Registration.account_id',
> 'Registration.attend' => 1)
> )),
> 'group' => array('Account.id')
> );
> $accounts = $this->find('all', $options);
I just played with the options until I got the query I wanted.
>
>>
--
Like Us on FaceBook https://www.facebook.com/CakePHP
Find us on Twitter http://twitter.com/CakePHP
---
You received this message because you are subscribed to the Google Groups
"CakePHP" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/cake-php.
For more options, visit https://groups.google.com/d/optout.
