Timeline for LEFT JOIN vs. LEFT OUTER JOIN in SQL Server
Current License: CC BY-SA 3.0
6 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| May 4, 2014 at 7:49 | review | Low quality answers | |||
| May 4, 2014 at 7:57 | |||||
| Aug 10, 2012 at 20:28 | history | suggested | Uncle Iroh | CC BY-SA 3.0 |
I'm quite certain he meant inner join, since outer and full are used together.
|
| Aug 10, 2012 at 20:08 | review | Suggested edits | |||
| Aug 10, 2012 at 20:28 | |||||
| Oct 5, 2009 at 18:16 | comment | added | Dave DuPlantis | tableA FULL OUTER JOIN tableB will give you three types of records: all records in tableA with no matching record in tableB, all records in tableB with no matching record in tableA, and all records in tableA with a matching record in tableB. | |
| Jan 2, 2009 at 20:29 | comment | added | Amy B | So... what's a FULL OUTER JOIN then? | |
| Jan 2, 2009 at 8:54 | history | answered | Unsliced | CC BY-SA 2.5 |