Microsoft SQL Server 語言參考 ... 連結圖示 Transact-SQL 語法慣例 ..... By default, SQL Server performs an INNER JOIN if only the JOIN -- keyword is specified.
msdn.microsoft.com