Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 11.0.1 (Français) » SQL Anywhere Server - SQL Usage » Querying and Modifying Data » Joins: Retrieving data from several tables » How joins work

 

The FROM clause

Use the FROM clause to specify which base tables, temporary tables, views or derived tables to join. The FROM clause can be used in SELECT or UPDATE statements. An abbreviated syntax for the FROM clause is as follows:

FROM table-expression, ...

where:

table-expression :
table-name 
| view-name 
| derived-table-name
| lateral-derived-table-name  
| join-expression 
| ( table-expression, ... )
| openstring-expression
| apply-expression
table-name or view-name:
[owner.] table-or-view-name [ [ AS ] correlation-name ]
derived-table-name :
( select-statement ) [ AS ] correlation-name [ ( column-name, ... ) ]
join-expression :
table-expression join-operator table-expression [ ON join-condition ]
join-operator:
[ KEY | NATURAL ] [ join-type ] JOIN 
| CROSS JOIN
join-type:
 INNER 
| FULL [ OUTER ] 
| LEFT [ OUTER ] 
| RIGHT [ OUTER ]
apply-expression :
table-expression { CROSS | OUTER } APPLY table-expression
join-condition : 

See Search conditions.

Notes

You cannot use an ON clause with CROSS JOIN.

For more syntax information, see FROM clause.