DeepFrontend
Learning Paths
Practice
System Design & DS
Design Studio
Data Structures Curriculum
Real-World Case Studies
Careers
Job Board
Resume Builder
Blog
Sign in
Search
⌘K
Go Pro
Loading compiler resources...
Databases Quiz Practice
Active Recall Drill Session
← Exit Session
Question 1 of 1
easy
Databases
What is the difference between an `INNER JOIN` and a `LEFT JOIN` in SQL?
A
INNER JOIN only joins tables on integer keys; LEFT JOIN joins on strings
B
INNER JOIN returns rows only where keys match in both tables; LEFT JOIN returns all rows from the left table regardless of matches in the right
C
INNER JOIN executes faster because it runs in memory; LEFT JOIN runs on disk
D
There is no difference; they are syntactic aliases
Check Answer