proposalbot
78ac771d84
DDM UMN 1st v Reviewed-by: Wagner, Fabian <fabian.wagner@t-systems.com> Co-authored-by: proposalbot <proposalbot@otc-service.com> Co-committed-by: proposalbot <proposalbot@otc-service.com>
1.1 KiB
1.1 KiB
- original_name
ddm-08-0010.html
SELECT JOIN Syntax
Common Syntax
table_references:
table_reference [, table_reference] ...table_reference:
table_factor | join_tabletable_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_factorjoin_condition:
ON conditional_expr
| USING (column_list)Syntax Restrictions
SELECT STRAIGHT_JOIN and NATURAL JOIN are not supported.
Example
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;