When working with CAATs,which of the following statements is false?
A) Inner join will show only the records from both tables that match and exclude everything that doesn't match.
B) Left join will show all records from the first table and only records from the second table that match.
C) Right join will show all records from the second table and records from the first table that match.
D) Outer join will show all records, including only matching ones.

Question

Quizplus · Accepted Answer

An outer join actually shows all records from both tables, including those that match and those that do not match. The statement as given incorrectly suggests that an outer join would only show matching records.

When Working with CAATs,which of the Following Statements Is False