title: Django filter a queryset based on another table without specified relationship
body: <p>Ok so this is probably a bit of an odd question, but here is my problem.  With out getting into too much detail I need to send a notice to properties but only if there is a corresponding title search.  Here are my models.  There is specified relationship between the two.  But they share a common value in a common field.  They both have a properties parcel number (the parcel number for the notice is in a related field accessible by the foreign key)</p>
  
  <pre><code>class Notice(models.Model):
      status_choice = [
          ("SendNotice", "SendNotice"),
          ("NoticeSent", "NoticeSent")
      ]
  
      violation_fk = models.OneToOneField(Violation, on_delete=models.CASCADE)
      date_created = models.DateTimeField(auto_now_add=True)
      notice_number = models.CharField(max_length=10)
      date_sent = models.DateTimeField(blank=True, null=True)
      status = models.CharField(choices=status_choice, max_length=10)
      instructions = models.TextField(blank=True, null=True)
  
  
  class TitleSearch(models.Model):
      address = models.CharField(max_length=50)
      parcel_number = models.CharField( max_length=24)
      title_search_date = models.DateField(auto_now=False, auto_now_add=False)
      expiration_date = models.DateField(auto_now=False, auto_now_add=False)
      owner = models.CharField(max_length=100)
      attn_line = models.CharField(max_length=150, blank=True)
      street_address = models.CharField(max_length=150)
      city = models.CharField(max_length=25)
      state = models.CharField(max_length=2)
      zip_code = models.CharField(max_length=5)
  </code></pre>
  
  <p>So.  here is my problem.  I cannot send a notice to a property without a title search.  BUT the title searches expire after a set period of time, so I don't necessarily want to tie them together.</p>
  
  <p>I am trying to get a queryset that will select all the notices that have a status of "SendNotice" AND have a non expired title search on file with the same parcel number.  Sort of a queryset check to make sure the parcel number is IN the list of active title searches.</p>
  
  <p>Thank you,</p>