Supplement of select statements-nested query and join query

In the previous blog, the SELECT statement of SQL Server briefly introduced the SELECT statement (the features, search scope, and clauses are described). However, I have omitted some of the statements and I want to add them now.

The SELECT statement is a query statement in nine SQL Server languages. For the SELECT statement, first look at this figure:

View branch-join query

Purpose: You can use join queries to retrieve data from one or more data tables based on the logical relationship between data tables.

Internal join:

Outer Join:

Cross join:

 View branches-nested Query