Using Inner Joins - TechNet - Microsoft

An inner join is a join in which the values in the columns being joined are compared using a ... The following Transact-SQL query is an example of an inner join:.

technet.microsoft.com