SQL Join: Combining Columns Based on Common Fields

The correct answer is C. Natural join.

Here's why:

A 'Natural Join' in SQL is specifically designed to combine columns from two tables based on columns with the same name and data type. It automatically matches rows based on these common columns, creating a single result table.

Other Join Types:

• Cross Join: Creates a result table where every row from the first table is paired with every row from the second table. It doesn't rely on common columns for joining.
• Left Outer Join: Returns all rows from the left table and matching rows from the right table. If there's no match in the right table, it adds NULL values.
• Right Outer Join: Similar to the left outer join, but returns all rows from the right table and matching rows from the left table. NULL values are added for unmatched rows in the left table.