i have three tables 1. Rates: [id, Price, CourseID, others...] 2. Course: [id, noofpoints, GCources_id, others....] 3. GCourcess: [id, WeekIncFriday, Type, others........]
i mapped relationship between them [Rates -> Cources -> Gcources] , now i want to get data from Rates and apply condition on GCources My Query is $this->Rate->Behaviors->attach('Containable'); $Rate = $this->Rate->find( 'first', array( 'conditions' => array( 'Rate.CourseID' => $courses_array ), 'contain' => array( 'Course' => array( 'GCourcess' => array( 'conditions' => array( 'GCourcess.WeekIncFriday' => 1 ) ) ) ) ) ); This generate error "Column not found: 1054 Unknown column 'GCourcess.WeekIncFriday' in 'where clause'" **My quastion how can i apply this condition GCourcess.WeekIncFriday = 1 from Rates table?** -- 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 post to this group, send email to cake-php@googlegroups.com. To unsubscribe from this group, send email to cake-php+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/cake-php?hl=en.