Using Inner Joins - TechNet - Microsoft

SQL Server 2000 ... In the SQL-92 standard, inner joins can be specified in either the FROM or ... This Transact-SQL query is an example of an inner join:

technet.microsoft.com