[EMAIL PROTECTED] wrote: > Is there anyway to dynamically override cake to use a JOIN instead of > LEFT JOIN ? >
I added a condition in my model to only return Job.active, but with the LEFT JOIN, it will always be return a record, but with the Job empty. So to exclude the row, I need to select by a JOIN, not a LEFT JOIN. SELECT `JobsTeamMember`.*, `Job`.*, `TeamMember`.* FROM `jobs_team_members` AS `JobsTeamMember` LEFT JOIN `jobs` AS `Job` ON (`Job`.`active` = 1 AND `JobsTeamMember`.`job_id` = `Job`.`id`) LEFT JOIN `team_members` AS `TeamMember` ON (`JobsTeamMember`.`team_member_id` = `TeamMember`.`id`) WHERE `JobsTeamMember`.`team_member_id` = 5 ORDER BY `Job`.`active` asc SELECT `JobsTeamMember`.*, `Job`.*, `TeamMember`.* FROM `jobs_team_members` AS `JobsTeamMember` JOIN `jobs` AS `Job` ON (`Job`.`active` = 1 AND `JobsTeamMember`.`job_id` = `Job`.`id`) LEFT JOIN `team_members` AS `TeamMember` ON (`JobsTeamMember`.`team_member_id` = `TeamMember`.`id`) WHERE `JobsTeamMember`.`team_member_id` = 5 ORDER BY `Job`.`active` asc --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "CakePHP" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~----------~----~----~----~------~----~------~--~---
