title: How do i return Django queryset only if value exists in another table?
body: <p>Maybe the late hour has my brain fried because I am sure this is incredibly easy. I want to return a queryset of all candidates that are in the the CallList of a particular Prospecting. My view is being passed the Prospecting id. I have read many posts on values and value lists, but I am struggling. Any help would be appreciated.</p>
  
  <p>Candidate.objects.filter(????)</p>
  
  <pre><code>class Prospecting(models.Model):
      name = models.CharField(max_length=40)
  
  class CallList(models.Model):
      prospecting = models.ForeignKey(Prospecting, on_delete=models.CASCADE, null=True)
      candidate = models.ForeignKey(Candidate, on_delete=models.CASCADE)
  
  class Candidate(models.Model):
      first_name = models.CharField(max_length=40)
      last_name = models.CharField(max_length=40)
  </code></pre>