title: SQL query - Dept and Employee table, some departments may not have managers
body: <p>There are two tables:</p>
  
  <pre><code>Employee 
  ---------
  emp_id
  emp_name 
  emp_contact 
  salary 
  mgr_emp_Id
  Dept_No 
  
  Dept 
  -----
  Dept_No
  Dept_name
  Dept_Location
  </code></pre>
  
  <p>Write a SQL statement to list all department names along with location and also manager name if a manager has been assigned to the department. Note that some departments still do not have a manager.
  Is the following correct?</p>
  
  <pre><code>SELECT Dept_name, Dept_Location, emp_name AS Mgr_name 
  FROM Dept 
  LEFT JOIN Employee ON (Dept.Dept_No = Employee.Dept_No AND mgr_emp_id = emp_id)
  </code></pre>
  
  <p>Can this be achieved without join too? If yes, how?</p>