Just to correct the query results as that was after modifying the schema. The full depth queries are:
SELECT `AThing`.`id`, `AThing`.`b_thing_id`, `BThing`.`id`, `BThing`.`c_thing_id` FROM `a_things` AS `AThing` LEFT JOIN `b_things` AS `BThing` ON (`AThing`.`b_thing_id` = `BThing`.`id`) WHERE `AThing`.`id` = 1 LIMIT 1 SELECT `BThing`.`id`, `BThing`.`c_thing_id` FROM `b_things` AS `BThing` WHERE `BThing`.`id` = 5 SELECT `CThing`.`id` FROM `c_things` AS `CThing` WHERE `CThing`.`id` = 10 If we add a name column to C_Things to make it have something useful, the query need just be: SELECT `AThing`.`id`, `AThing`.`b_thing_id`, `BThing`.`id`, `BThing`.`c_thing_id`,`CThing`.`name` FROM `a_things` AS `AThing` LEFT JOIN `b_things` AS `BThing` ON (`AThing`.`b_thing_id` = `BThing`.`id`) LEFT JOIN `c_things` as `CThing` on (`BThing`.`c_thing_id` = `CThing`.`id`) WHERE `AThing`.`id` = 1 LIMIT 1; This is presumably a bug or weakness in the current DB implementation. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Cake PHP" 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 -~----------~----~----~----~------~----~------~--~---
