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

By the end of this page you can predict, before you run it, how many rows any join will return. You will know all six join types and what each keeps. You will know the two ways a join goes wrong witho