title: Does it make a difference to change the order of JOIN ON condition?
body: <p>Assume that I have a table <code>EMPLOYEES</code> that has 100,000 rows.
  And I have <code>DEPENDENTS</code> table which has 200,000 rows.</p>
  
  <p>I can obtain a list of all dependents with their relation from employees table (<code>EMPLOYEES</code> has a column <code>EMP_ID</code> which is a foreign key in <code>DEPENDENTS</code> with the name <code>PARENT_EMP_ID</code>).</p>
  
  <pre><code>SELECT
      D.FIRST_NAME,
      D.LAST_NAME,
      E.EMPLOYEE_NAME AS DEPENDENT_OF
   FROM
      DEPENDENTS D
      LEFT JOIN EMPLOYEES E ON D.PARENT_EMP_ID = E.EMP_ID
  </code></pre>
  
  <p>My question is:
  Would it make any difference if I joined the table like this:</p>
  
  <pre><code>...
  FROM DEPENDENTS D 
  LEFT JOIN EMPLOYEES E ON D.PARENT_EMP_ID = E.EMP_ID
  </code></pre>
  
  <p>versus:</p>
  
  <pre><code>...
  FROM DEPENDENTS D 
  LEFT JOIN EMPLOYEES E ON E.EMP_ID = D.PARENT_EMP_ID
  </code></pre>
  
  <p>Notice, that I have changed the order of the condition, preserving the order of the tables themselves since I need all rows from dependents (not caring if I get duplicates from EMPLOYEES table).</p>