title: Django Models and SELECT with joined two or more tables?
body: <p>How can I make an select with two (or more) joined tables using Django Models?</p>
  
  <p>For example:</p>
  
  <pre><code>class Album(models.Model):
      artist = models.ForeignKey(Musician)
      name = models.CharField(max_length=100)
      release_date = models.DateField()
      num_stars = models.IntegerField()
  
  class Song(models.Model):
      album = models.ForeignKey(Album)
      name = models.CharField(max_length=100)
      num_stars = models.IntegerField()
  
  SELECT * from album, song where (album.id = song.album_id) and (album.artist_id = X)
  </code></pre>