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