I found the sfProplFinder plugin to work wonders with this kind of multi-table query:
http://redotheweb.com/2008/06/27/a-finder-smarter-than-propel-getters/ Hope this helps, have a great weekend. Daniel On Jul 10, 10:01 pm, kusum <[EMAIL PROTECTED]> wrote: > hi, > i want to join three table in this format .and it is working > properly,but it is giving only fields of listing table.and i want to > get selected fields from all these three tables and i want to use > object of listing table .In this format it is possible or not.and > if it is possible than what will be the pattern of query. > > $c=new Criteria(); > $c->addJoin(BuilderProjectPeer::OWNER_ID, OwnerPeer::ID); > $c->addJoin(ListingPeer::OWNER_ID,BuilderProjectPeer::OWNER_ID); > > $c->addJoin(ListingPeer::OWNER_ID,OwnerPeer::ID); > $c->setLimit(5); > $c->addAscendingOrderByColumn('RAND()');//line 47 > $checkrecord = ListingPeer::doSelect($c); --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "symfony users" 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/symfony-users?hl=en -~----------~----~----~----~------~----~------~--~---
