Blog 03 – Week 6

This week we covered SQL Joins, handed in Milestone One and started work on Milestone Two.

Joins are used to combine two tables using a column from each table that is used to find matching data that determines what is joined. This can be used to find relevant data from other tables using a select statement.
SELECT tableOneData, tableTwoData
FROM tableOne as t1
JOIN tableTwo as t2
ON t1.exampleColumn = t2.exampleColumn