I'm reasonably fluent in SQL, and while I've found Django's ORM is great for basic CRUD operations, I'm having trouble creating joins.
For example, I have a three tables, Article, Rating, and User. Rating stores a user's rating of a particular article. I'm trying to create a view that lists articles, and optionally shows the current user's rating of each article, if they've made one. To query the rating record along with the article in SQL, this would just be a simple left outer join. How would this be done with Django's ORM? I've reviewed http://www.djangoproject.com/documentation/model-api/#relationships but I don't think it covers this case. Regards, 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?hl=en -~----------~----~----~----~------~----~------~--~---