Re: Joins Conditions Contain Question

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
cake-php+unsubscribe@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php