Inner join « Table Join « SQL Server / T-SQL Tutorial

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. with the qualified * operator