Hi Manoj, Here is your answer, two different solutions :
The very clean one (but it needs a hack) : http://www.rabaix.net/articles/2006/9/16/propel-complex-on-clause The quick and dirty one: $c = new Criteria(); $c->addJoin(Table1Peer::ID,Table2Peer::TABLE1_ID.' AND '.Table1Peer::USER_ID.' = 27',Criteria::LEFT_JOIN); Just put the condition concatenated after the second column ! I have not tested it but I was told (by Thomas Rabaix) that it works fine. And considering my experience on Propel, direct hacks like this one usually work :-) Fabrice --~--~---------~--~----~------------~-------~--~----~ 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 [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/symfony-users?hl=en -~----------~----~----~----~------~----~------~--~---
