sql-join Flashcards

1
Q

What is a foreign key?

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

How do you join two SQL tables?

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

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

A

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

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly