title: Is there any significance in the order of table in sql join statement
body: <p>Is there any significance in the order of table in sql join statement. For example</p>
  
  <pre><code>SELECT dept_name, emp_name 
  FROM   Employee 
  INNER JOIN Department ON Employee.dept_id = Department.dept_id
  </code></pre>
  
  <p>and</p>
  
  <pre><code>SELECT dept_name, emp_name 
  FROM Department 
  INNER JOIN Employee  ON Employee.dept_id = Department.dept_id
  </code></pre>
  
  <p>Is there is any performance advantage in the order of tables?</p>