From and select clause t

FROM and SELECT Clause T-SQL In this tutorial we will give you a few examples about the FROM and SELECT clauses. This tutorial is meant for beginners who have just began learning about T-SQL. We will not cover the complete syntax of FROM and SELECT clause in this tutorial.

Let’s begin with the FROM clause.

The FROM clause specifies one or more tables containing the data that the query retrieves from.

The FROM clause has a few roles. One role it plays is an indicator of the table you want to query. Also in the from clause you use operators like joins which are used to join two or more tables and table hints which are used to override the default behavior of the query optimizer.