Question

Which of the following join selects all rows from both the tables as long as the condition satisfies?

पर्याय

• Inner Join

• Left Join

• Right Join

• Natural Join

Answer 1

Inner Join

Explanation:

The INNER JOIN keyword generates a result set by joining all rows from both tables when the condition is met, i.e. the value of the common field is the same.