sql-join-Q&A

Question 1

What is a foreign key?

Answer 1

That column specifically refers to values in a column of a table.

Question 2

How do you join two SQL tables?

Answer 2

With a join statement with a column that both tables share

Question 3

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

Answer 3

“tableName”.”columnName” as “newColumnName”