A SQL join is combines records from two or more tables in a relational database by using values common to each.
The SQLite Joins clause is used to combine records from two or more tables in a database. A JOIN is a means for combining fields from two tables by using values common to each.