Explain the differences between inner, outer, left, and cross joins.
💡 Model Answer
INNER JOIN returns only matching rows from both tables. LEFT JOIN (or LEFT OUTER JOIN) returns all rows from the left table and matching rows from the right; unmatched right rows are NULL. RIGHT JOIN does the opposite, returning all rows from the right table. FULL OUTER JOIN returns all rows from both tables, with NULLs where there is no match. CROSS JOIN returns the Cartesian product of the two tables, combining every row of the first with every row of the second. Each join type serves a different data retrieval need.
This answer was generated by AI for study purposes. Use it as a starting point — personalize it with your own experience.
🎤 Get questions like this answered in real-time
Assisting AI listens to your interview, captures questions live, and gives you instant AI-powered answers — invisible to screen sharing.
Get Assisting AI — Starts at ₹500