Joins Flashcards
1
Q
What records are returned from an (INNER) JOIN?
A
returns records that have matching values in both tables
2
Q
What records are returned from a LEFT (OUTER) JOIN?
A
returns all records from left table and matched records from the right
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
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