sql-join

Question 1

What is a foreign key?

Answer 1

A foreign key is a column in a database table that references the primary key of another table.

Question 2

How do you join two SQL tables?

Answer 2

SELECT column1, column2, …
FROM table1
JOIN table2
ON table1.column = table2.column;

Question 3

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

Answer 3

SELECT column_name AS new_column_name
FROM table_name;