sql-join

Question 1

What is a foreign key?

Answer 1

When you have a column with a specific key that is the value of another table’s row id – this is a foreign key. Instead of putting all of the information from another row – you just put a row key that knows where to look

Question 2

How do you join two SQL tables?

Answer 2

using select, from and join using a specific attribute

Question 3

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

Answer 3

using the as clause