Mastering INNER, LEFT, and RIGHT Joins
Published September 08, 2026
By Sai Sree Ram 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;