ACARA 9-10 Digital Technologies: Joining tables with SQL

Students use JOIN with ON conditions, qualified names and aliases to combine related tables, including three-table joins and the pitfalls of a missing ON condition.

One content description (AC9TDI10P03) from the full ACARA Digital Technologies Years 9–10 — Entities, Relationships and Queries journey. All 8 modules below are in that journey too, with the same content — add just these to a class, or the whole strand.

Modules (8)

1 Why a query over two tables needs a join 2 SQL JOIN across two tables 3 Writing the ON condition: foreign key equals primary key 4 Table-qualified field names in a join 5 Table aliases in a join 6 A join with WHERE and ORDER BY 7 Joining three tables 8 A join that forgets the ON condition

Add to class →

For Teachers

Add this journey to your class and track every student in real time.

Create a free teacher account →

No credit card. No setup fee. Make a class and invite students in under three minutes.

For Students

Start this journey on Cloodit — track progress, earn badges, and play live sprints with your class.

Start Learning Free →

Have a class code?