sql-join Flashcards

1
Q

What is a foreign key?

A

a foreign key is shared bettween two tables

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 key word for columns, specifiying from which tables, then join table using match keyword

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” key word

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