You have to change the condition so that the check for NULL is done on the foreign key, not on the Policy table, so the condition becomes:
WHERE `Notification`.`user_id` = 'adffd636' AND ((`Policy`.`status` = 0) OR (`Notification`.`policy_id` IS NULL)) LIMIT 15 Enjoy, John -- 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
