Hi! Thank you very much. I will try this query, though it will take me some time to merge to my app.
For now thanks buddy, and have a good night! (It is very late for me :D ) 2011/6/7 winzou <alexandre.ba...@gmail.com> > Ok, you're stuck on an pure SQL issue. Check this query: > SELECT a, b FROM objectA a LEFT JOIN objectB b ON (objectB.id_a = > objectA.id AND objectB.is_public_content = true) > > The trick is to put the condition in the ON, not in the WHERE. > > -- > If you want to report a vulnerability issue on symfony, please send it to > security at symfony-project.com > > 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 > -- If you want to report a vulnerability issue on symfony, please send it to security at symfony-project.com 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