Sql join Flashcards

1
Q

What is a foreign key?

A

A key from/referencing a column from 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

join “table” using (reference column)

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

“table” as “temp name”

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