Re: Containable and Aggregate fields

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 cake-php+unsubscribe@googlegroups.com.
To post to this group, send email to cake-php@googlegroups.com.
Visit this group at http://groups.google.com/group/cake-php.
For more options, visit https://groups.google.com/d/optout.