Learn how SQL joins work with detailed explanations and examples.
The diagram above shows how 4 types of SQL joins work in detail.
Returns matching rows in both tables.
Returns all records from the left table, and the matching records from the right table.
Returns all records from the right table, and the matching records from the left table.
Returns all records where there is a match in either left or right table.
API and Web Development
Real World Case Studies
AI and Machine Learning
Database and Storage
Technical Interviews
Caching & Performance
Payment and Fintech
Software Architecture
DevTools & Productivity
Software Development
Cloud & Distributed Systems
How it Works?
DevOps and CI/CD
Security
Computer Fundamentals