title: Use any join result is same. Why so?
body: <p>I have two tables, <code>A</code> and <code>B</code>:</p>
  
  <ul>
  <li><code>A</code> with 3 rows all 1, 1, 1 with single column</li>
  <li><code>B</code> with 2 rows all 1 1 with single column</li>
  </ul>
  
  <p>I used all available joins on these the tables the o/p is same:</p>
  
  <pre><code>A   B
  1   1
  1   1
  1   1
  1   1
  1   1
  1   1
  </code></pre>
  
  <p>How are these joins working?</p>
  
  <p>I face these question in a interview with a MNC.</p>