> > >

MySQL MCQs

What is the difference between an inner join and an outer join?

Inner join returns only rows from the first table; outer join returns rows from both tables

Inner join deletes rows that don't match; outer join does not delete any rows

Inner join returns only rows from both tables that match on the given conditional expression

Answer

Correct Answer: Inner join returns only rows from both tables that match on the given conditional expression

Explanation:

Note: This Question is unanswered, help us to find answer for this one

MySQL Skill Assessment

Your Skill Level: Poor

Retake Quizzes to improve it