Skip to content
Extras
Chinook Sample Database
SQLite Browser
SQL Murder Mystery
SQL ISland
SQLZoo
SQL Cheat Sheet
Topics
Topic 1 – Navigating Databases
Topic 2 – Editing Entries
Topic 3 – Flat File Database Design
Topic 4 – Relational Database Design
Topic 5 – Advanced Queries
Topic 6 – SQL and Python
Topic 7 – SQL & Python project
Navigation Menu
Navigation Menu
Extras
Chinook Sample Database
SQLite Browser
SQL Murder Mystery
SQL ISland
SQLZoo
SQL Cheat Sheet
Topics
Topic 1 – Navigating Databases
Topic 2 – Editing Entries
Topic 3 – Flat File Database Design
Topic 4 – Relational Database Design
Topic 5 – Advanced Queries
Topic 6 – SQL and Python
Topic 7 – SQL & Python project
Advanced Queries
Starter
Simple Join
SELECT
table1.column
FROM
table1
INNER JOIN
table2
ON
table1.primary_key_column
=
tabl2.foreign_key_column
;