Where clause

• Condition in the same line as WHERE keyword

  Option: fmt017_where_condition_in_newline = false, type: TFmtBoolean.

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

  • AND/OR keyword at the end of line

    Option: fmt019_where_condition_andor = at_the_end_of_line, type: TFmtANDOR.

    SELECT e.employee_id, 
           d.location_id  
    FROM   employees e,departments d  
    WHERE  e.department_id = d.department_id AND
           e.last_name = 'Matos';  

  • AND/OR keyword at the begin of line, align with condition

    Option: fmt019_where_condition_andor = at_the_begin_of_line, type: TFmtANDOR.

    SELECT e.employee_id, 
           d.location_id  
    FROM   employees e,departments d  
    WHERE  e.department_id = d.department_id
           AND e.last_name = 'Matos';  

  • AND/OR keyword at the begin of line, align with WHERE keyword

    Option: fmt019_where_condition_andor = at_the_begin_of_line_right_align_with_main_keyword, type: TFmtANDOR.

    SELECT e.employee_id, 
           d.location_id  
    FROM   employees e,departments d  
    WHERE  e.department_id = d.department_id
      AND  e.last_name = 'Matos';  

• Condition in new line, indented from 1 to n

  Option: fmt017_where_condition_in_newline = true, type: TFmtBoolean.

  Option: fmt018_where_condition_indent = n, type: int.

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

  • AND/OR keyword at the end of line

    SELECT e.employee_id, 
           d.location_id  
    FROM   employees e,departments d  
    WHERE  
      e.department_id = d.department_id AND
      e.last_name = 'Matos';  

  • AND/OR keyword at the begin of line, align with condition

    SELECT e.employee_id, 
           d.location_id  
    FROM   employees e,departments d  
    WHERE  
      e.department_id = d.department_id
      AND e.last_name = 'Matos';  

  • AND/OR keyword at the begin of line, align with WHERE keyword

    Option: fmt019_where_condition_andor = at_the_begin_of_line_outside, type: TFmtANDOR.

    SELECT e.employee_id, 
           d.location_id  
    FROM   employees e,departments d  
    WHERE  
        e.department_id = d.department_id
    AND e.last_name = 'Matos';