title: SQL Query Join 2 tables
body: <p>I'm new to SQL and was reading on joins but i'm a bit confused so wanted help....</p>
  
  <p>I have a table called student_sport which stores StudentID and SportID</p>
  
  <p>I have another table which stores details of matches... so basically sportsID,MatchId,....</p>
  
  <p>What i wanna do is.... for a perticular student display the sports in which matches have been played. ie. if a sportID exists in the second table only then display that when i check which sports the student plays.</p>
  
  <p>The resultSet should contain only those sports for a student in which matches have been played....</p>
  
  <p>Thanks</p>