When is a left join not a left join? | Jacob Ferraiolo’s Blog
Introduction One of the most common issues I see, even amongst experienced analysts and engineers, is the misuse of left joins. This post deals with the proper usage of join conditions vs. where constraints in left joins. I’ve seen numerous cases where getting this wrong has cost companies thousands of dollars.
When is a left join not a left join? | Jacob Ferraiolo’s Blog
Introduction One of the most common issues I see, even amongst experienced analysts and engineers, is the misuse of left joins. This post deals with the proper usage of join conditions vs. where constraints in left joins. I’ve seen numerous cases where getting this wrong has cost companies thousands of dollars.
https://ferraijv.github.io/posts/data/2024/04/08/left-join.html