Updated on 2022-08-12 GMT+08:00

join_condition

Syntax

Description

Syntax

Description

join_condition

Judgment condition of join.

and

Logical operator: AND

or

Logical operator: OR

not

Logical operator: NOT

(

Start of the subjudgment condition.

)

End of the subjudgment condition.

condition

Judgment condition.

const_set

Collection of constants, which are separated by using comma (,).

in

Keyword used to determine whether attributes are in the same collection.

atrrs_value_set_expr

Collection of attribute values.

attr_expr

Attribute expression.

Equality and inequality

Equation and inequality. For details, see Relational Operators.

pattern_string

Pattern matching string, which supports wildcard matching. In WHERE LIKE, SQL wildcard characters "%" and "_" are supported. "%" represents one or more characters. "_" represents only one character.