Database Management MySQL Subjective
Oct 01, 2025

What are the different types of SQL JOINs? Provide examples.

Detailed Explanation

INNER JOIN: Returns matching records from both tables
LEFT JOIN: Returns all records from left table and matching from right
RIGHT JOIN: Returns all records from right table and matching from left
FULL OUTER JOIN: Returns all records when there is a match in either table

Example:
SELECT u.name, o.order_date
FROM users u
INNER JOIN orders o ON u.id = o.user_id;

Discussion (0)

No comments yet. Be the first to share your thoughts!

Share Your Thoughts
Feedback