Really interested in why simply doing two finds and merging the results would not do as you'll be processing all rows either way. What number of rows do you expect to query in total so I can understand the performance aspect of this. Would love to know your eventual outcome
Mike Karthauser Brightstorm limited Tel: 07939252144 On 29 Oct 2009, at 19:23, "[email protected]" <[email protected] > wrote: > > I have two tables: > > houses > houses_stat > > The two tables are the same but old data from "houses" are moved to > "houses_stat" by a cron job. > > Now I want to find all houses in both tables where "price" equals > "1000" > > A find in one table would be: > $houses->find("all", array("conditions" => array("price" => 1000))); > > but how do I lookup data in both tables in one find? > > How do I do that? > > Do I need to use some kind of bindModel or? > > > --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
