Using Inner Joins. SQL Server 2008 R2. Other Versions ... are known as old-style inner joins. The following Transact-SQL query is an example of an inner join:.
technet.microsoft.com