3 ms·
I also remember only a single "can't-use-a-left-join" problem. Left joins express "Give me these things, and these other sub-things related to them". Object or
by dotancohen 5y ago
I also remember only a single "can't-use-a-left-join" problem.
Left joins express "Give me these things, and these other sub-things related to them". Object oriented programming lends itself towards the thing-with-subthings (and collections of things-with-subthings) so I feel that the left join is the default choice for most applications which are structured with the classic OOP approach.
I wonder if full joins are more common in other programming paradigms, such as whatever those crazy lisp folks talk about.