hi radu, i think this should work for you.........
$c = new Criteria(); // Create Aliasses $c->addAlias("U1", UsersPeer::TABLE_NAME); $c->addAlias("T3_2", UsersPeer::TABLE_NAME); // Create Joins $c->addJoin(ArticlePeer::CREATEDBY_ID, UsersPeer::alias("U1", UsersPeer::ID)); $c->addJoin(ArticlePeer::CREATEDBY_ID, UsersPeer::alias("U2", UsersPeer::ID)); $this->articleList = ArticlePeer::doSelect($c); On Fri, Feb 27, 2009 at 7:07 PM, korfos <kor...@gmail.com> wrote: > > Hello all, > I'm new to symfony, so be gentle :) > > I have to tables: > users {id, name} > article{id, createdby_id, modifiedby_id} > createdby_id and modifiedby_id are foreign keys to users table > > When i do: > > $c = new Criteria(); > $c->addJoin(ArticlePeer::CREATEDBY_ID, UsersPeer::ID); > $c->addJoin(ArticlePeer::MODIFIEDBY_ID, UsersPeer::ID); > $this->articleList = ArticlePeer::doSelect($c); > > the resulting sql is: > > SELECT article.ID, article. CREATEDBY_ID, article. MODIFIEDBY_ID FROM > article, users WHERE article. CREATEDBY_ID=users.ID AND article. > MODIFIEDBY_ID=users.ID > > my question is: is there a way to make the sql look like this? > > SELECT article.ID, article. CREATEDBY_ID, article. MODIFIEDBY_ID FROM > article, users u1, users u2 WHERE article. CREATEDBY_ID=u1.ID AND > article. MODIFIEDBY_ID=u2.ID > > Thank you, > Radu. > > > -- Regards, Dheeraj --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "symfony users" group. To post to this group, send email to symfony-users@googlegroups.com To unsubscribe from this group, send email to symfony-users+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/symfony-users?hl=en -~----------~----~----~----~------~----~------~--~---