sql-join

Question 1

What is a foreign key?

Answer 1

A key that links a table to another in the database

Question 2

How do you join two SQL tables?

Answer 2

select *
from xxx
(join clause) using (a column)

Question 3

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

Answer 3

creating alias using the as clause