3 ms·
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'
by gjreda 13y ago
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.
- siddboots 13y agoFor that matter, most queries work nicely if you avoid null attributes altogether, and stick to (LEFT INNER) JOIN, WHERE ... IN, UNION, INTERSECT and EXCEPT.