title: django select records from multiple tables with same foreign key
body: <p>I would like to execute a single query in Django which retrieves related data, by foreign key, in multiple tables. At present I have to run a query on each table e.g. (House, Furniture, People) using the House number as a filter.</p>
  <p>In SQL I can do this in one query like this:</p>
  <pre><code>SELECT house.number, house.number_of_rooms, furniture.type, people.name
  FROM (house INNER JOIN furniture ON house.number = furniture.house_number) 
  INNER JOIN people ON house.number = people.house_number
  WHERE (((house.number)=&quot;21&quot;));
  </code></pre>
  <p>Can this be done in Django?</p>
  <p>See example models below:</p>
  <pre><code>class House(models.Model):
      number = models.CharField('House Number', max_length=10, blank=True, unique=True, primary_key=True)
      number_of_rooms = models.IntegerField(default=1, null=True)
  
  class Furniture(models.Model):
      house_number = models.ForeignKey(House, on_delete=models.CASCADE, null=True)
      type = models.CharField('Furniture Type', max_length=50)
  
  class People(models.Model):
      house_number = models.ForeignKey(House, on_delete=models.CASCADE, null=True)
      first_name = models.CharField('First Name', max_length=50)
  
  </code></pre>