The output result number of rows depends on the type of join used.

• Inner join returns only the matching rows from both tables

• Left join returns all rows from the left table and matching rows from the ri...read more