For more information about a list of rowset functions, see Rowset Functions (Transact-SQL). Specifies one of the rowset functions, such as OPENROWSET, which returns an object that can be used instead of a table reference. For more information, see Table Hints (Transact-SQL). Specifies that the query optimizer uses an optimization or locking strategy with this table and for this statement. When a derived table, rowset or table-valued function, or operator clause (such as PIVOT or UNPIVOT) is used, the required table_alias at the end of the clause is the associated table name for all columns, including grouping columns, returned. The table name can't be used if an alias is defined. If the same column name exists in more than one table in the join, SQL Server may require that the column name is qualified by a table name, view name, or alias to distinguish these columns.

An alias is frequently a shortened table name used to refer to specific columns of the tables in a join. table_aliasĪn alias for table_source that can be used either for convenience or to distinguish a table or view in a self-join or subquery. When OPENDATASOURCE is specified, database_name and schema_name may not apply to all data sources and is subject to the capabilities of the OLE DB provider that accesses the remote object. A four-part name that is constructed by using the OPENDATASOURCE function as the server part of the name can also be used to specify the remote table source. For more information, see sp_addlinkedserver (Transact-SQL). If the table or view exists outside the instance of SQL Serverl, use a four-part name in the form linked_server. If the table or view exists in another database on the same instance of SQL Server, use a fully qualified name in the form database. SQL Server returns errors when duplicate names appear in the FROM clause. The order of table sources after the FROM keyword doesn't affect the result set that is returned. These include the presence of indexes and indexed views on each and the size of the in the SELECT statement.

Compilation and optimization time is also affected by additional factors.

Query performance may suffer with lots of tables referenced in a query. Syntax for SQL Server and Azure SQL Database: [ FROM APPLY right_table_source This article also discusses the following keywords that can be used on the FROM clause: The exception is when no table columns are listed, and the only items listed are literals or variables or arithmetic expressions. The FROM clause is usually required on the SELECT statement. In Transact-SQL, the FROM clause is available on the following statements: SQL Server 2016 (13.x) and later Azure SQL Database Azure SQL Managed Instance Azure Synapse Analytics Analytics Platform System (PDW) SQL analytics endpoint in Microsoft Fabric Warehouse in Microsoft Fabric

Sql pivot