Using Inner Joins

An inner join is a join in which the values in the columns being joined are compared using a comparison operator. ... This inner join is known as an equi-join. It returns all the columns in both tables, and returns only the rows for which there is an equa

technet.microsoft.com