SQL Join: Which join combines all rows from both tables?

The correct answer is 'B. Cross Join'.

A 'Cross Join' produces a result set that contains every possible combination of rows from the two tables involved. This means that if table A has 'm' rows and table B has 'n' rows, the resulting table will have 'm * n' rows.

Here's why the other options are incorrect:

• Outer Join: An outer join includes all rows from one table and matching rows from the other table. If a match is not found, null values are added to the result set.* Natural Join: A natural join combines rows from two tables based on matching column names, without requiring an explicit join condition.* None of them: This option is incorrect as a cross join does exist and fulfills the requirement of combining each row of one table with each row of another table.