SQL JOIN

Code pattern

Jump to a topic

See every item in the sequence

Definition

Combines rows from two or more tables by matching a primary key to a foreign key (INNER JOIN ... ON a.id = b.id).

Example

FROM Student JOIN Class ON Student.ClassID = Class.ClassID

Found in: syllabus, school notes.

Where you'll use it in the test

Syllabus area: Y12 Programming for the Web.

Question types it can appear in

SQL: Join tables (familiarisation Q12b, sample Q17)
Multi-select: fam Q2
Matching or table: ORM v SQL (2025 Q9)

Where it has appeared in the paper

Programming for the Web (Part A, B, C). Part letters follow each paper’s own layout.

How to use it

A model sentence

General advice, built from the definition and example above

Code pattern: “Combines rows from two or more tables by matching a primary key to a foreign key (INNER JOIN ...” Then apply it: FROM Student JOIN Class ON Student.ClassID = Class.ClassID

In a short answer, give the definition in your own words first, then tie it to the situation in the question. Do not copy the example above unless it fits the scenario.

Official worked answer

Familiarisation Q12b (3 marks): SQL (joins, AS) (3 marks): official criteria and sample answer

Criteria

3: Correct SQL query. 2: Substantially correct query with at least TWO of: renaming the columns; selecting the three tables; joining the tables. 1: Some understanding of renaming the columns or joining the tables.

Sample answer

SELECT Customers.CustName as 'Customer', Products.ProductName as 'Product', Orders.OrderQuantity as 'Quantity' FROM Products, Customers, Orders WHERE Orders.ProductID = Products.ProductID AND Orders.CustID = Customers.CustID ORDER BY Orders.OrderID ASC

Open the question page

Go deeper

Flashcard: SQL JOIN in Programming for the Web (Year 12) · study that set
Memorise: SQL vs ORM
Full term page: every question, note and marking comment for SQL JOIN

Check yourself

Write or say the “SQL JOIN” pattern from memory: the syntax and what it does.

Reveal the answer