Question: What happens when an inner join is performed between tables A and B ? Combines the corresponding rows in table A with rows in table
What happens when an inner join is performed between tables A and B
Combines the corresponding rows in table A with rows in table B if the condition evaluates to True.
Combines corresponding rows in table A with rows in table B if the condition evaluates to True. Else, NULL values are assigned to the rows from the table B in the temporary table.
Combines every row in table A with every row in table B
Combines two rows if the values in the common columns are same.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
