The syntax for an inner join that uses correlation names : Inner join « Table Join « SQL Server / T-SQL Tutorial






SELECT select_list
FROM table_1 [AS] n1
    [INNER] JOIN table_2 [AS] n2
        ON n1.column_name operator n2.column_name
   [[INNER] JOIN table_3 [AS] n3
        ON n2.column_name operator n3.column_name]...








4.3.Inner join
4.3.1.The explicit syntax for an inner join
4.3.2.The syntax for an inner join that uses correlation names
4.3.3.An inner join with correlation names that make the query more difficult to read
4.3.4.Select distinct value from inner join
4.3.5.Inner join two table with column in common
4.3.6.Inner join with where clause
4.3.7.Once you decide to alias a table, you must use that alias in every part of the query.
4.3.8.works with the qualified * operator