sql-join

Question 1

What is a foreign key?

Answer 1

column whose value references a row from another table

Question 2

How do you join two SQL tables?

Answer 2

SELECT *
FROM “products”
JOIN “suppliers” USING (“supplierId”);

Question 3

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

Answer 3

SELECT "p"."name" AS "product",
              "p"."category",
              "s"."name" AS "supplier",
              "s"."state"
  FROM "products" AS "p"
    JOIN "suppliers" AS "s" USING ("supplierId");