Codible SQLite video 6: SQLite3 - how a JOIN works

Describes how a JOIN of two tables works in SQLite, with a simple example. Shows how a "cartesian product" of the two tables is first formed, and then a filter is applied based on the common field in both tables.