SQL JOIN Flashcards

1
Q

What is a foreign key?

A

Shared data values that link to 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

select “Column”
from”table1”
join “table2” using “foreignkey”

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

“column” as “whateverName”

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