Is 'LEFT OUTER JOIN' equivalent to 'JOIN' in Microsoft SQL

On this MSDN page, it shows that these are equivelant;

LEFT OUTER JOIN or LEFT JOIN

My question, in MSSQL is

JOIN

also equivalent to

LEFT JOIN

Solution 1:

No.

JOIN is equivalent to INNER JOIN.

Check this example.
Since it returned the rows, we can assume it's an INNER JOIN.

and checking documentation:

INNER
Specifies all matching pairs of rows are returned. Discards unmatched rows from both tables. When no join type is specified, this is the default.

Also, according to this post, the type-part of the JOIN clause is optional:

For instance, the entire type-part of the JOIN clause is optional, in which case the default is INNER if you just specify JOIN.

Solution 2:

For instance, the entire type-part of the JOIN clause is optional, in which case the default is INNER if you just specify JOIN.

-Source LEFT JOIN vs. LEFT OUTER JOIN in SQL Server