Joins Flashcards

1
Q

What records are returned from an (INNER) JOIN?

A

returns records that have matching values in both tables

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

What records are returned from a LEFT (OUTER) JOIN?

A

returns all records from left table and matched records from the right

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

What records are returned from a RIGHT (OUTER) JOIN?

A

returns all records from the right table and matched records from the left

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

What records are returned from a FULL (OUTER) JOIN?

A

returns all records where there is a match in either left or right table

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