From clause

• Table sources in the same line

  Option: fmt007_select_table_list_style = fit_into_one_line, type: TFmtListStyle.

  • First table source item in the same line as FROM keyword

    Option: fmt009_select_table_in_newline = false, type: TFmtBoolean.

    Option: fmt011_select_table_list_comma_option = after_item_with_1_space, type: TFmtCommaOption.

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

  • First table source in new line, indent by 1 or n

    Option: fmt009_select_table_in_newline = true, type: TFmtBoolean.

    Option: fmt010_select_table_indent = n, type: int.

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

• Stacked table source

  Option: fmt007_select_table_list_style = stacked, type: TFmtListStyle.

  • First table source item in the same line as FROM keyword

  • comma after item

    Option: fmt011_select_table_list_comma_option = after_item, type: TFmtCommaOption.

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

  • comma before item, first item align with comma

    Option: fmt011_select_table_list_comma_option = before_item_inside_list, type: TFmtCommaOption.

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

  • comma before item, first item align following items.

    Option: fmt011_select_table_list_comma_option = before_item_outside_list, type: TFmtCommaOption.

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

  • comma before item, first item align following items, space between comma and item is 1 or n.

    Option: fmt011_select_table_list_comma_option = before_item_outside_list_with_n_space, type: TFmtCommaOption.

    Option: fmt012_select_table_list_comma_space = n, type: int.

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

  • First table source item in a new line, indent from 1 to n.

  • comma after item

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

  • comma before item, first item align with comma

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

  • comma before item, first item align following items.

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

  • comma before item, first item align following items, space between comma and item is 1 or n.

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