Example of an INNER JOIN across three tables

three-table-join.sql

CREATE VIEW ClassesAndRunningInformation AS
SELECT 
  ClassGroup.Name AS ClassGroupName,
  Running.StartDate,
  Module.Name AS ModuleName,
  Module.Length AS ModuleLength
FROM
  ClassGroup
    INNER JOIN
  Running
    ON ClassGroup.Id = Running.ClassGroup_Id
    LEFT JOIN
  Module
    ON Running.Module_Id = Module.Id;