title: Joining three tables expecting results but the result is wrong
body: <p>This is my table:</p>
  
  <pre><code>user table:
  id..|..fname
  1...|..dan
  2...|..den
  
  trans table:
  .transid.|..userid....|..adid.....|..click
  .....1...|....1.......|.....1.....|.....1
  .....2...|....2.......|.....1.....|.....1
  
  ads table:
  id..|..adname
  1...|..sample
  </code></pre>
  
  <p>And my select clause is:</p>
  
  <pre><code>select u.fname, 
         t.click 
  from user u 
     inner join ads a on u.id=a.id 
     inner join trans t on a.id=t.transid 
  order by u.fname;
  </code></pre>
  
  <p>I was expecting a result of</p>
  
  <pre><code>fname....|..click
  dan......|...1...
  den......|...1...
  </code></pre>
  
  <p>but the result was wrong, it only shows the first line. What could be wrong here?</p>