sql-join

Question 1

What is a foreign key?

Answer 1

A column that references a column from another table

Question 2

How do you join two SQL tables?

Answer 2

select key, from, name of table, join, name of second table

Question 3

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

Answer 3

add “as”, followed by the alias