title: Join two tables based on relationship defined in third table
body: <p>I have two tables Activity and Action. One or more actions can be performed for an activity. And the relationships between Activity and Action is given in a third table called Activity Action.</p>
  
  <p>How do I retrieve a result set that tells me what action is applicable for each activity using an sql statement? Here's the table structure</p>
  
  <p><strong>Activity Table</strong> -ActivityId(PK), ActivityText</p>
  
  <p><strong>Action Table</strong> - ActionId(PK), ActionText</p>
  
  <p><strong>ActivityAction</strong> -ActivityActionId(PK), ActivityID, ActionID</p>
  
  <p>I want a resultant table in the format</p>
  
  <p><em>Activity, Applicable Action</em></p>
  
  <p>(the Activity column should show ActivityText and Applicable Action should show ActionText)</p>
  
  <p>could you please guide me?</p>
  
  <p>Thank you.</p>