Brainscape's Knowledge GenomeTM

Browse over 1 million classes created by top students, professors, publishers, and experts.


See full index

SQL and Databses > Joins > Flashcards

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

SQL and Databses (3 decks)

Brainscape helps you reach your goals faster, through stronger study habits.
© 2024 Bold Learning Solutions. Terms and Conditions