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.