title: MySql inner join returning all the results as if it's left or cross join
body: <p>I have a simple query which is not giving the desired results. The query is a follows</p>
  
  <pre><code>select * 
  from friends_nudges a 
       INNER JOIN user_friends b 
        ON a.user_id = b.user_id 
  where a.user_id = 104 and 
        nudge_sent = 1 
  order by nudge_sent_time asc
  </code></pre>
  
  <p>Somehow this query is returning all the results of both the tables.</p>