分布式数据库中间件 DDM
分布式数据库中间件 DDM
- 最新动态
- 服务公告
- 产品介绍
- 计费说明
- 快速入门
- 用户指南
- API参考
- SDK参考
- 最佳实践
- 性能白皮书
- 常见问题
- 视频帮助
- 文档下载
- 通用参考
更新时间:2022-09-23 GMT+08:00
链接复制成功!
SELECT JOIN Syntax
常用语法
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)
语法限制
不支持SELECT STRAIGHT_JOIN 和 NATURAL JOIN。
示例
select id,name from test1 where id=1; select distinct id,name from test1 where id>=1; select id,name from test1 order by id limit 2 offset 2; select id,name from test1 order by id limit 2,2; select 1+1,'test',id,id*1.1,now() from test1 limit 3; select current_date,current_timestamp; select abs(sum(id)) from test1;
父主题: DML