3 ms·

This is my pet peeve. Top google search results and ChatGPT suggest this "same number of rows" mental model which is incomplete and breaks. I wrote about this

This is my pet peeve. Top google search results and ChatGPT suggest this "same number of rows" mental model which is incomplete and breaks. I wrote about this: https://minimalmodeling.substack.com/p/many-explanations-of-join-are-wrong https://minimalmodeling.substack.com/p/many-explanations-of-...

shiandow 3y ago
The reason why this misunderstanding is so pervasive is probably because joins are effectively function application (or function composition, bit of the same thing really). I also wrote about this ;-) https://pragmathics.nl/2023/10/24/putting-the-relational-back-in-relational-databases/#functions https://pragmathics.nl/2023/10/24/putting-the-relational-bac...