SQL-Join

Question 1

What is a foreign key?

Answer 1

A column that is shared between multiple tables that links them together

Question 2

How do you join two SQL tables?

Answer 2

Using the JOIN clause followed by the table name you want to join in double parentheses. Which then is followed by the foreign key column that is shared between the tables.

Question 3

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

Answer 3

By aliasing them with the as keyword