SQL-JOIN Flashcards

1
Q

What is a foreign key?

A

A number that links one table 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

from which table you want to join –> join table using(attribute)

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

As clause

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