title: Difficult SQL statement... Four tables?
body: <p>I've put together a database, which I believe follows all the "right" ways of doing things, (No redundant data, etc.) as shown below:</p>
  
  <p><img src="https://i.stack.imgur.com/J1fWw.png" alt="enter image description here"></p>
  
  <p>I wish to display the data stored in the <strong>Nominations</strong> table, but by a certain <em>EventID</em>, and with the film <em>Title</em> and <em>Year</em>, and the award <em>Name</em>. I know basic joins, but this seems to be quite complicated -- because I'm a newb. Any help about the right way of approaching this problem, so I can face more complicated ones in the future, is much appreciated!</p>