sql-join Flashcards

1
Q

What is a foreign key?

A

A key that links a table to another in the database

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 *
from xxx
(join clause) using (a 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

creating alias using the as clause

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