sql-join

Question 1

What is a foreign key?

Answer 1

A column that is used to establish a link between the data in two tables

Question 2

How do you join two SQL tables?

Answer 2

Join “table name” using (“foreign key”)

Question 3

How do you temporarily rename columns or tables in a SQL statement?

Answer 3

Use ‘as’ (ex: “table name” as “alias”