Advertisements
Advertisements
Question
Which of the following join selects all rows from both the tables as long as the condition satisfies?
Options
Inner Join
Left Join
Right Join
Natural Join
MCQ
Solution
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.
shaalaa.com
Using Two Relations in Query
Is there an error in this question or solution?
