Codible SQLite video 5: SQLite 3 - joining and querying two or three tables HD
This video describes how to join two or three tables (inner join) to query the results. Joining two tables is a good way to combine information that is stored in separate tables, into one view.