SQL Reference Guide > SQL Reference Guide > SQL Statements > UPDATE > FROM Clause
Was this helpful?
FROM Clause
The FROM clause in the UPDATE statement specifies the source tables and views from which data is to be read. The specified tables and views must exist at the time the query is issued. The from_source parameter can be:
• One or more tables or views, specified using the following syntax:
[schema.]table [[AS] corr_name]
where table is the name of a table, view, or synonym.
• A join between two or more tables or views, specified using the following syntax:
source join_type JOIN source ON search_condition
or
source join_type JOIN source USING (column {, column})
or
source CROSS JOIN source
For details about specifying join sources, see ANSI/ISO Join Syntax.
• A derived table (see Subqueries in the FROM Clause (Derived Tables)) specified using the following syntax:
(select_stmt) corr_name [(column_list)]
where select_stmt is a SELECT statement with no ORDER BY clause, corr_name is a mandatory correlation name, and column_list is an optional list of override names for the columns in the SELECT list of the select_list.
• A table procedure (see Table Procedure) specified using the following syntax:
proc_name ([param_name=]param_spec {,[param_name=]param_spec})
A maximum of 126 tables can be specified in a query, including the tables in the FROM list, tables in subselects, and tables and views resulting from the expansion of the definitions of any views included in the query.
Last modified date: 08/29/2024