Explain INNER JOIN vs OUTER JOIN in SQL.

Explain INNER JOIN vs OUTER JOIN in SQL.

• A. INNER JOIN returns rows with matching keys in both tables; OUTER JOIN returns matched rows plus unmatched rows from one or both sides.
• B. INNER JOIN returns all rows; OUTER JOIN returns only matching rows.
• C. INNER JOIN sorts results by keys.
• D. INNER JOIN duplicates data.

Answer: (A)