SQL JOINs: How to Join Two Tables Without Losing or Doubling Rows

Every join concept in the order they build on each other: the pair rule, grain, all six join types, the silent delete, the silent multiply, the two counts that catch each one, and the edge cases that break joins in real data. Worked on 41 million row