jquery - Fetch data from two tables Python -

hi need fetch data 2 tables id of first in foreign key other

this code

def allplayers(request):     cursor = connection.cursor()     player_list = myplayer.objects.all()     get_player_vital=[]     in player_list:         get_player_vital = [vitals.objects.filter(playerid =i.id )]      paginator = paginator(player_list, 25) # show 25 contacts per page      page = request.get.get('page')     try:         contacts = paginator.page(page)     except pagenotaninteger:         # if page not integer, deliver first page.         contacts = paginator.page(1)     except emptypage:         # if page out of range (e.g. 9999), deliver last page of results.         contacts = paginator.page(paginator.num_pages)      return render_to_response('allplayers.html', {"contacts": contacts,'get_player_vital':get_player_vital}) 

when print get_player_vital in template returns last record

you need smth this, guess:

def allplayers(request):     player_list = myplayer.objects.all()     get_player_vital = [vitals.objects.filter(playerid__in=player_list.values_list('id', flat=true))]    ...    return render_to_response('allplayers.html', {"contacts": contacts,'get_player_vital':get_player_vital}) 

because create new list object every iteration loop, consists of 1 object.