title: How to use Entry.objects.filter() in two tables in Django?
body: <p>I have two tables in Django: First one is <code>file</code> which has the file information and second one is <code>share</code> which has the shared information:
  <code>files_id</code> is foreign key to <code>Share</code> table:
  Now, I want to retrieve file information(from File table) which has files_id in shared table. How can I do that?</p>
  
  <pre><code>#models.py
  class File(models.Model):
      users = models.ForeignKey(User)
      file_name = models.CharField(max_length=100)
      type = models.CharField(max_length=10)
      source = models.CharField(max_length=100)
      start_date = models.TextField()
      end_date = models.TextField()
      duration = models.TextField()
      size = models.TextField()
      flag = models.TextField()
      #delete_date = models.CharField(max_length=100, null=True, blank=True)
  
  class Share(models.Model):
      users = models.ForeignKey(User)
      files = models.ForeignKey(File)
      shared_user_id = models.IntegerField()
      shared_date = models.TextField()
  </code></pre>
  
  <p>I want to get the file_information with users_id is log_id and get the shared_date too. I get log_id as: <code>log_id = request.user.id</code> </p>