SQL Joins Flashcards
1
Q
What is an inner join (or just join)?
A
Keeps only the records in which the key field is in both tables
2
Q
What is a LEFT JOIN? (RIGHT)
A
Keeps all fields in the left table, and all matches in the right (Opposite)
3
Q
What happens to fields that don’t match on LEFT/RIGHT/FULL JOINS?
A
Listed as missing values
4
Q
What is a FULL JOIN?
A
All values in both tables
5
Q
What is a CROSS JOIN?
A
Gives all combinations of rows from both tables
