title: Joining multiple tables (Following/Activity)
body: <p>I have 2 tables</p>
  
  <p><strong>Following</strong></p>
  
  <pre><code>id
  User_ID
  Following_user_ID
  </code></pre>
  
  <p>The <code>User_ID</code> is following the <code>Following_user_ID</code></p>
  
  <p><strong>Activity</strong></p>
  
  <pre><code>A_ID
  User_ID
  Shared
  </code></pre>
  
  <p>(The <code>User_ID</code> column is the user that inserted the data into the tables.)</p>
  
  <p>How would I build the query to select all of the activity rows where the currently logged in user is following the user in the User_ID column of Activity.</p>
  
  <p><em>EXAMPLE</em></p>
  
  <p><strong>Following</strong></p>
  
  <pre><code>id = 1
  User_ID = 1
  Following_user_ID = 2
  </code></pre>
  
  <p>User 1 is following user 2</p>
  
  <p><strong>Activity</strong></p>
  
  <pre><code>A_ID = 1
  User_ID = 2
  Shared = Blah Blah
  </code></pre>
  
  <p>How can I make it so that user 1 (currently logged in) can see the activity of User 2 as user 1 is following user 2?</p>
  
  <p>From the example above, user 1 should be able to see along the lines of "User 2 shared Blah Blah".</p>
  
  <p>I have tried to explain this the best I can, have been trying to figure out the query but can't wrap my head around it.</p>