Back to marketplace
SQL Joins
No description yet. This curated deck is ready for daily study.
Total cards: 5•Content version: v3•Public deck•Updated: 8/1/2026
Card preview (5)
#1
Front (Question)
What is an inner join (or just join)?
Back (Answer)
Keeps only the records in which the key field is in both tables
#2
Front (Question)
What is a LEFT JOIN? (RIGHT)
Back (Answer)
Keeps all fields in the left table, and all matches in the right (Opposite)
#3
Front (Question)
What happens to fields that don’t match on LEFT/RIGHT/FULL JOINS?
Back (Answer)
Listed as missing values
#4
Front (Question)
What is a FULL JOIN?
Back (Answer)
All values in both tables
#5
Front (Question)
What is a CROSS JOIN?
Back (Answer)
Gives all combinations of rows from both tables