Which of the following is the default join between two recordsets? A. Inner join B. Left outer join C. Right outer join D. Self join

The answer is A. Inner join.

An inner join is a join between two tables that returns all rows from both tables where there is a match on the join columns. In other words, it returns all rows from the left table that have a matching row in the right table, and all rows from the right table that have a matching row in the left table.

A left outer join is a join between two tables that returns all rows from the left table, and the matching rows from the right table, if there is a match on the join columns. In other words, it returns all rows from the left table, even if there is no matching row in the right table, and all rows from the right table that have a matching row in the left table.

A right outer join is a join between two tables that returns all rows from the right table, and the matching rows from the left table, if there is a match on the join columns. In other words, it returns all rows from the right table, even if there is no matching row in the left table, and all rows from the left table that have a matching row in the right table.

A self join is a join between two tables that have the same name. In other words, it is a join between two tables that are related to each other.

The default join between two recordsets is an inner join. This is because an inner join is the most common type of join, and it is the most efficient type of join.