sql-join

Question 1

What is a foreign key?

Answer 1

A foreign key is a column of a table that refers to another column in another table.

or

A foreign key is a column whose name and values are shared between two columns.

Question 2

How do you join two SQL tables?

Answer 2

select *
from (name of table in double quotes)
join (name of table in double quotes) using (name of column in both tables in double quotes surrounded by parentheses)

Question 3

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

Answer 3

select (name of table in double quotes).(shared column name in double quotes) as (new name in double quotes)
(name of second table in double quotes).(shared column name in double quotes) as (new name in double quotes)
from (name of first table in double quotes)
join (name of second table in double quotes) using (other shared column name in double quotes surrounded by parentheses)