Timeline for LEFT JOIN vs. LEFT OUTER JOIN in SQL Server
Current License: CC BY-SA 3.0
4 events
when toggle format | what | by | license | comment | |
---|---|---|---|---|---|
Jul 6, 2016 at 10:39 | comment | added | onedaywhen |
"it is clear only 3 cases exist": interesting but flawed. Consider that an inner join is a specialised cross join (i.e. move join predicates to the where clause). Further consider that outer join isn't a join at all, rather is a union where are used nulls in place of 'missing' columns. Therefore, it could be argued that cross is the only join required. Note the current thinking in relational theory is that natural join satisfies all join requirements. Aside: can you explain if/how the vocabulary "JOIN implies INNER JOIN " fits with your reasoning for outer join vocab?
|
|
Apr 17, 2014 at 21:38 | review | Late answers | |||
Apr 17, 2014 at 21:39 | |||||
Apr 17, 2014 at 21:15 | history | edited | Yugo Amaryl | CC BY-SA 3.0 |
added 56 characters in body
|
Apr 17, 2014 at 21:08 | history | answered | Yugo Amaryl | CC BY-SA 3.0 |