title: Joining SQL Tables
body: <p>I have two tables:</p>
  
  <p>RecommendedFriends and AddedFriends</p>
  
  <p>each of the tables have a User field and a Friend field. I am trying to figure out how I can see how many friends a User added that they were also recommended. Heres an example of the tables:</p>
  
  <pre><code>RecommendedFriends
  User    Friends     Time
  ------------------------------------
  Jake    Eric        8:00am
  Jake    John        8:00am
  Jake    Jack        8:30am
  Greg    John        8:30am
  Greg    Tim         9:00am
  Greg    Steve       9:30am
  Will    Jackson     9:30am
  
  AddedFriends
  User    Friends     Time
  ------------------------------------
  Jake    Jack        8:35am
  Greg    John        8:35am
  Greg    Tim         9:00pm
  Greg    Jim         10:30am
  Greg    Tina        10:45am
  Greg    Bob         10:00am
  Charlie Brian       11:00am
  </code></pre>
  
  <p>So the table I need would look like this:</p>
  
  <pre><code>Results
  User    RecFriends  AddFriends   
  ------------------------------------
  Jake    Eric        
  Jake    John        
  Jake    Jack        Jack
  Greg    John        John
  Greg    Tim         Tim
  Greg    Steve       
  Greg                Tina
  Will    Jackson     
  Charlie             Brian
  </code></pre>
  
  <p>So I can go in and say 3 people added friends they were recommended, 4 Recommendations failed, and 2 people added someone they weren't recommended.</p>