Where clause

• Condition in the same line as WHERE keyword

  SELECT e.employee_id, 
         d.location_id  
  FROM   employees e,departments d  
  WHERE  e.department_id = d.department_id  

• Condition in new line, indented from 1 to n

  SELECT e.employee_id, 
         d.location_id  
  FROM   employees e,departments d  
  WHERE  
    e.department_id = d.department_id