sql-join

Question 1

What is a foreign key?

Answer 1

one column word/key that links two separate tables (column found in both tables)

Question 2

How do you join two SQL tables?

Answer 2

use the join clause after a from clause followed by the table name you want to join, and then with the using keyword and then the column name (foreign key) with double quotes inside parentheses

Question 3

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

Answer 3

use the as keyword to rename; ex: “products” as “p” for renaming tables, and “product”.”name” as “product” for columns (.”name” is original name of column).