The FROM clause of a join statement names all the tables (or views) involved in the join. FROM is the clause that actually indicates to SQL Server that a join is desired. The order in which the tables (or views) are listed in the FROM clause affects the results display only when you use * in the select list.
Although this chapter uses only tables in its examples, views can be joined in exactly the same way as tables. Table or view names can be qualified by the names of the owner and database and can be given alias names for convenience. You can specify more than two tables or views in the FROM clause. (For details, see Joining More Than Two Tables.)