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