Re: null ForeignKey and INNER JOIN

Hi, > > Is there a way to switch django's relationship building from INNER > > JOIN to LEFT OUTER JOIN ? > > It causes unexpected behaviour when filtering on both parent and child > > tables. > > Not really. There is a limited ability to control the join behaviour > with Q objects, but this isn't

Re: null ForeignKey and INNER JOIN

On 9/19/07, olivier <[EMAIL PROTECTED]> wrote: > > Hi all, > > Is there a way to switch django's relationship building from INNER > JOIN to LEFT OUTER JOIN ? > It causes unexpected behaviour when filtering on both parent and child > tables. Not really. There is a limited ability to control the jo

Re: null ForeignKey and INNER JOIN

Yups, sorry, the query would be build with Q objects : Q(title__icontains = 'cooking') | Q(collection__name__icontains = 'cooking') But the JOIN problem remains. Olivier --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google