4 ms·
You sure? I tend to think in terms roughly like this when I'm selecting a JOIN: https://dk81.github.io/dkmathstats_site/set-theory-sql.html https://dk81.github.
by flir 3y ago
You sure? I tend to think in terms roughly like this when I'm selecting a JOIN: https://dk81.github.io/dkmathstats_site/set-theory-sql.html https://dk81.github.io/dkmathstats_site/set-theory-sql.html
Eg (A LEFT JOIN B) = (A ∩ B) + A
Maybe I'm missing something though.
- hermitcrab 3y agohttps://blog.jooq.org/say-no-to-venn-diagrams-when-explaining-joins/ https://blog.jooq.org/say-no-to-venn-diagrams-when-explainin...
- flir 3y agoHmm. It's true, the set model breaks down when you remove the key relationship, or add filters.