From clause (join)

• Join clause at the same level with from clause

  Option: fmt013_join_indent = 0, type: int.

  • Table in join clause not at new line

    Option: fmt014_join_table_in_newline = false, type: TFmtBoolean.

    SELECT p.Name, sod.SalesOrderID
    FROM Production.Product AS p
    LEFT OUTER JOIN Sales.SalesOrderDetail AS sod
    ON p.ProductID = sod.ProductID

  • Table in join clause at new line

    Option: fmt014_join_table_in_newline = true, type: TFmtBoolean.

    Option: fmt015_join_table_indent = 4, type: int.

    SELECT p.Name, sod.SalesOrderID
    FROM            
        Production.Product AS p
    LEFT OUTER JOIN 
        Sales.SalesOrderDetail AS sod
    ON p.ProductID = sod.ProductID

• Join clause at the sub level with from clause

  Option: fmt013_join_indent = 5, type: int.

  • Join table not in new line

    Option: fmt014_join_table_in_newline = false, type: TFmtBoolean.

    SELECT p.Name, sod.SalesOrderID
    FROM Production.Product AS p
         LEFT OUTER JOIN Sales.SalesOrderDetail AS sod
         ON p.ProductID = sod.ProductID

  • Join table in new line

    Option: fmt014_join_table_in_newline = true, type: TFmtBoolean.

    Option: fmt015_join_table_indent = 2, type: int.

    SELECT p.Name, sod.SalesOrderID
    FROM Production.Product AS p
         LEFT OUTER JOIN 
           Sales.SalesOrderDetail AS sod ON p.ProductID = sod.ProductID

• ON condition

• On the same line with table source

  Option: fmt016_join_on_in_newline = false, type: TFmtBoolean.

  SELECT p.Name, sod.SalesOrderID
  FROM 
    Production.Product AS p
  LEFT OUTER JOIN Sales.SalesOrderDetail AS sod ON p.ProductID = sod.ProductID

• On a new line

  Option: fmt016_join_on_in_newline = true, type: TFmtBoolean.

  Option: fmt090_join_on_indent = n, type: TFmtInt.

  SELECT p.Name, sod.SalesOrderID
  FROM 
    Production.Product AS p
  LEFT OUTER JOIN Sales.SalesOrderDetail AS sod
    ON p.ProductID = sod.ProductID