title: Outer join giving same results as inner join if using where clause
body: <p>The following SQL statement:  </p>
  
  <pre><code>select * from employees e   
  left join departments d on e.deptid = d.deptid   
  where ( d.deptname = 'HR' or d.deptname  = 'HR &amp; Accounts')    
  </code></pre>
  
  <p>Produces the same results as the following inner join:  </p>
  
  <pre><code>select * from employees e  
     inner join departments d on e.deptid = d.deptid and d.deptname like '%HR%';  
  </code></pre>
  
  <p>In what way they produce the same result.  </p>
  
  <p>I mean is the first query equivalent e.g. of:  </p>
  
  <ol>
  <li>Select * from employees and filter using where</li>
  <li>Do left join?  </li>
  </ol>
  
  <p>What are the steps of the first query that make it the same as the inner join?</p>