分布式数据库中间件 DDM-SELECT JOIN Syntax:常用语法

时间:2025-02-24 20:32:04

常用语法

table_references:

table_reference [, table_reference] ...

table_reference:

table_factor | join_table

table_factor:

tbl_name [[AS] alias]
| table_subquery [AS] alias
| ( table_references )

join_table:

table_reference [INNER | CROSS] JOIN table_factor [join_condition]
| table_reference {LEFT|RIGHT} [OUTER] JOIN table_reference join_condition
| table_reference [{LEFT|RIGHT} [OUTER]] JOIN table_factor

join_condition:

ON conditional_expr
| USING (column_list)
support.huaweicloud.com/usermanual-ddm/ddm-08-0010.html