Mastering INNER, LEFT, and RIGHT Joins

Published on: July 26, 2025 | Published by: Sai Sreeram Gundepudi

INNER JOIN

SELECT e.name, d.name 
FROM employees e 
JOIN departments d ON e.dept_id = d.id;

LEFT JOIN

SELECT e.name, d.name 
FROM employees e 
LEFT JOIN departments d ON e.dept_id = d.id;

RIGHT JOIN

SELECT e.name, d.name 
FROM employees e 
RIGHT JOIN departments d ON e.dept_id = d.id;