CollegeTeam.objects.filter(team=game.team1) | CollegeTeam.objects.filter(team=game.team2)
But I would instead recommend: CollegeTeam.objects.filter(team__in=[game.team1, game.team2]) Erik On 20.10.2008, at 1:22, [EMAIL PROTECTED] wrote: > > I have a model that is tracking all of the college football games, > there's an entry for each game, with the two teams represented in the > fields 'team1' and 'team2'. These are foreign keys to the model > 'CollegeTeams'. I'm trying to run a query so that it'll get the > results from the Game for each team and display it on the team page. > > So I have Game.objects.all() to get all of the games, then what I know > to do would be CollegeTeam.objects.filter(team=game.team1), but what I > want is to get the team if they're team1 or team2. I looked through > the docs and say how do to a lot of variations on the queries, but > didn't see a way to use the objects.filter() with the OR statement. > Any help? Quick example of the query I'm trying to run below. > > SELECT from CollegeTeam WHERE team1 = CollegeTeam.id OR team2 = > CollegeTeam.id > > --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---