Using linking tables for many to many relationships in MySQL

Demonstration on a way to support many to many relationships in a relational database like MySQL. Also showing how to use an SQL JOIN to select data from the tables.