CodeBlend CodeBlend - 4 months ago 13
SQL Question

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

aF. aF.
Answer

No.

JOIN is equivalent to INNER JOIN.


Check THIS example.
Since it returned the rows we can assume that's a 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 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.

Comments