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
Asked
Active
Viewed 2.7k times
50
-
7`LEFT JOIN` is not equal to `JOIN`. The default `JOIN` is `INNER`. – Neil Knight Feb 09 '12 at 10:29
-
Where in the document does it say `LEFT JOIN` is equivalent to `JOIN`? – Eric Mar 29 '19 at 17:33
2 Answers
89
No.
JOIN is equivalent to INNER JOIN.
Check this example.
Since it returned the rows, we can assume it's an INNER JOIN.
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.
bubbleking
- 3,329
- 3
- 29
- 49
aF.
- 64,980
- 43
- 135
- 198
3
For instance, the entire type-part of the JOIN clause is optional, in which case the default is INNER if you just specify JOIN.
-
I believe my answer more directly answers the question but I can't accept my answer until two days have passed – Paul C Feb 09 '12 at 10:39
-
if you say so. But I think you have made a question for a yes or no answer and I don't see a yes or no in your answer :P – aF. Feb 09 '12 at 10:40
-
Hey, fair enough, you include my answer as well plus then you get rep so win win. – Paul C Feb 09 '12 at 10:46
-