Skip to main content

Timeline for LEFT JOIN vs. LEFT OUTER JOIN in SQL Server

Current License: CC BY-SA 4.0

15 events
when toggle format what by license comment
Jun 3, 2022 at 11:02 history edited philipxy CC BY-SA 4.0
This diagram is irrelevant to the question and even if it were relevant it is unclear, unhelpful & misleading (& uncreditied)--see my comments on the question post.
S Jul 24, 2019 at 8:23 history suggested WBT CC BY-SA 4.0
Remove grammatical inference that optional means no impact.
Jul 24, 2019 at 2:53 review Suggested edits
S Jul 24, 2019 at 8:23
Aug 30, 2018 at 20:47 review Suggested edits
Aug 30, 2018 at 21:13
May 23, 2017 at 10:31 history edited URL Rewriter Bot
replaced http://stackoverflow.com/ with https://stackoverflow.com/
Oct 12, 2015 at 15:56 comment added dnoeth According to Standard SQL OUTER is also an optional keyword: <join type> ::= INNER | <outer join type> [ OUTER ]
S Sep 24, 2014 at 19:56 history suggested abSiddique CC BY-SA 3.0
Ad i image to simply all !
Sep 24, 2014 at 19:34 review Suggested edits
S Sep 24, 2014 at 19:56
May 2, 2013 at 7:40 comment added nawfal @LasseV.Karlsen I just meant that the left side has the concise form and the right side has the expanded form. I thought it would make it coherent if you followed the same for JOINs as well.
May 1, 2013 at 14:55 comment added nawfal @LasseV.Karlsen wouldnt it be better to have INNER JOIN on the right and just JOIN on the left in the list of equivalents?
Jan 15, 2012 at 5:08 history edited Mahmoud Gamal CC BY-SA 3.0
added 14 characters in body
Dec 23, 2011 at 8:04 history edited Lasse V. Karlsen CC BY-SA 3.0
Edited answer in response to comment
Jan 5, 2009 at 7:52 vote accept KG Sosa
Jan 2, 2009 at 21:34 comment added Sean Reilly Absolutely correct. OUTER is allowed for ANSI-92 compatibility.
Jan 2, 2009 at 8:51 history answered Lasse V. Karlsen CC BY-SA 2.5