Re:A Visual Explanation of SQL Joins (2007)
by gjreda on Monday May 27, 2013 @01:15PM
(#5775476)
I like that this only covers left outer joins as opposed to left and right outer joins.
The difference between the two is sometimes confusing for people, so I've always suggested that people learn one and stick with it, since you can accomplish the exact same thing with either.
Re:A Visual Explanation of SQL Joins (2007)
by siddboots on Monday May 27, 2013 @07:32PM
(#5777153)
For that matter, most queries work nicely if you avoid null attributes altogether, and stick to (LEFT INNER) JOIN, WHERE ... IN, UNION, INTERSECT and EXCEPT.
The difference between the two is sometimes confusing for people, so I've always suggested that people learn one and stick with it, since you can accomplish the exact same thing with either.