title: what is the basic difference between INNER JOIN and LEFT JOIN?
body: <p>I am running the following two queries but both of them are giving the same output.</p>
  
  <p><strong>Query 1</strong></p>
  
  <pre><code>SELECT * FROM EMP LEFT JOIN DEPT
  ON EMP.EMP_ID = DEPT.EMP_ID
  </code></pre>
  
  <p><strong>Query 2</strong></p>
  
  <pre><code>SELECT * FROM EMP INNER JOIN DEPT
  ON EMP.EMP_ID = DEPT.EMP_ID
  </code></pre>
  
  <p>THESE both queries give the same output i.e. all rows from both the tables.
  As far as I know <code>left join</code> should give only rows from the first table i.e. "EMP" and not from other table (DEPT).</p>
  
  <p>thanks.</p>