Why don't you try to create next condition in your query, 'Detail.comment_date < Incident.exp_date'
2011/6/30 Quarck <quarcks...@gmail.com>: > [0] => Array > ( > [Incident] => Array > ( > [id] => 37 > [start_date] => 2010-10-08 > [exp_date] => 2010-10-14 > [incoming_num] => 453-10 > [incoming_date] => 2010-10-08 > ) > [Detail] => Array > ( > [0] => Array > ( > [id] => 98 > [incident_id] => 37 > [comment_id] => 1 > [comment_date] => 2010-10-11 10:07:29 > [notify_only] => 0 > ) > [1] => Array > ( > [id] => 99 > [incident_id] => 37 > [comment_id] => 2 > [comment_date] => 2010-10-11 17:01:09 > [notify_only] => 0 > ) > [2] => Array > ( > [id] => 100 > [incident_id] => 37 > [comment_id] => 3 > [comment_date] => 2010-10-12 09:08:01 > [notify_only] => 0 > ) > ) > ) > [1] => Array > How can I select only those Incident.id, whose last Detail.comment_date < > Incident.exp_date? Is it possible to compare in cakephp fields from > different tables? Thans as advance for any assistant. > > -- > 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 > cake-php+unsubscr...@googlegroups.com For more options, visit this group at > http://groups.google.com/group/cake-php > -- Pozdrawiam Dominik Gajewski -- 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 cake-php+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php