ViewJoin

JOIN clause between primary and a non-primary ViewTable.

targetTarget (string)필수

alias of the ViewTable this join introduces

kindJoinKind (string)

Allowed Join Kind values. Values: inner, left, right, full.

Possible values: [inner, left, right, full]

기본값: inner

on object[]필수

AND'd binary conditions

Array [

left object필수

Join condition operand. Exactly one of column / expression set.

column object

Backing column reference in 'alias.col' form

하나 이상(anyOf)

• string
• null

string

expression object

SQL fragment when the operand is a computed expression

하나 이상(anyOf)

• string
• null

string

right object필수

Join condition operand. Exactly one of column / expression set.

column object

Backing column reference in 'alias.col' form

하나 이상(anyOf)

• string
• null

string

expression object

SQL fragment when the operand is a computed expression

하나 이상(anyOf)

• string
• null

string

operatorJoinOperator (string)

Allowed Join Operator values. Values: eq, ne, gt, gte, lt, lte.

Possible values: [eq, ne, gt, gte, lt, lte]

기본값: eq

]

ViewJoin

{
  "target": "string",
  "kind": "inner",
  "on": [
    {
      "left": {
        "column": "string",
        "expression": "string"
      },
      "right": {
        "column": "string",
        "expression": "string"
      },
      "operator": "eq"
    }
  ]
}