sql-join

Question 1

What is a foreign key?

Answer 1

A foreign key is column on one table that refers to the values in a specific column in another table.

Question 2

How do you join two SQL tables?

Answer 2

With join clause
select *
from “tableName”
join “anotherTable” using (“columnName”)

Question 3

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

Answer 3

Using “as” keyword after the column or table names.

ex: select “products”.”name” as “product”