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. |