Category: java
JOIN in SQL
Published on 24 Feb 2026
Explanation
INNER JOIN returns matching records from both tables.
Code:
SELECT u.name,o.id FROM users u INNER JOIN orders o ON u.id=o.user_id;
Explanation
LEFT JOIN returns all records from left
table and matched records from right table.
Code:
SELECT u.name,o.id FROM users u LEFT JOIN orders o ON u.id=o.user_id;
Explanation
RIGHT JOIN returns all records from right
table and matched records from left table.
Code:
SELECT u.name,o.id FROM users u RIGHT JOIN orders o ON u.id=o.user_id;
Explanation
JOIN using alias improves readability.
Code:
SELECT u.name FROM users u INNER JOIN orders o ON u.id=o.user_id;
Explanation
JOIN with WHERE condition filters combined results.
Code:
SELECT u.name,o.id FROM users u INNER JOIN orders o ON u.id=o.user_id WHERE u.id=1;