Joined Tables

Page 1

Inner Join - connects tables through condition

SELECT Fornename, Surname, AwardedBy, Reason

FROM Students INNER JOIN Rewards

ON Students.ID = Rewards.studentID

WHERE awardedBy = "MRussell"

Cross Join - finds every possible combination

SELECT forename, surname

FROM Students, Rewards

Filtered Cross Join - filters the Cross Join with a condition

SELECT forename, surname

FROM Students, Rewards

WHERE Students.id = Rewards.studentID

AND awardedBy = "MRussell"