title: Trouble with Joins (SQL on Oracle)
body: <p>I have a few tables:</p>
  
  <p><a href="http://i.stack.imgur.com/oPEv8.png" rel="nofollow">See them here</a></p>
  
  <p>I need to get some data from them both. I must list all Computer Science Alumni from 2014 (from AlumnusDeg table), and include their name email and home phone number (from Alumnus table). </p>
  
  <p>The following code returns the Computer Science Alumni from 2014:</p>
  
  <pre><code>SELECT * FROM AlumnusDeg 
  WHERE DegreeName LIKE '%Computer Science%' 
  AND YearGraduated = '2014';
  </code></pre>
  
  <p>However every other attempt at also getting the remaining FirstName, LastName, Email and HomeNo just aren't working.</p>
  
  <p>Finally, I must create this as a view.</p>