SQL Join

Question 1

How do you join two SQL tables?

Answer 1

With the ‘join’ keyword and the ‘using’ keywords

Question 2

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

Answer 2

By using Alias’

select “products”.”name” as “product”,
“suppliers”.”name” as “supplier”
from “products”
join “suppliers” using (“supplierId”);

select "p"."name" as "product",
       "p"."category",
       "s"."name" as "supplier",
       "s"."state"
  from "products" as "p"
  join "suppliers" as "s" using ("supplierId");