JOINS with SQLite

Joining is the defining functionality of SQL and sets it apart from other data technologies.

The INNER JOIN allows us to merge two tables together. But if we are going to merge tables, we need to define a commonality between the two so records between the two line up.