> Try going into the interactive interpretter (python manage.py shell) > and importing your models, then try: > > query=item1.sub_item_set.filter(options__name__exact="Small").filter(options__name__exact="Blue") > > then inspect the resulting SQL query components by executing: > > print query._get_sql_clause() > > Review it to make sure the underlying select looks like what you expect > it should. > > -- William > > That's a great tip. I examined the code & it looked right. I even ran the SQL directly and received the same results. Therefore, I think my logic is wrong or that I'm trying to do something convoluted from an SQL perspective. So, any ideas how I can do this?
Thanks, Chris --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Django users" group. To post to this group, send email to django-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/django-users -~----------~----~----~----~------~----~------~--~---