Which of the following is NOT true regarding outer joins?
A)The OUTER JOIN clause returns all rows from two or more of the tables within the FROM clause,as long as those rows meet any WHERE or HAVING search conditions.
B)The OUTER JOIN clause is used whenever multiple tables that are accessed through a SQL SELECT statement returns all of the records from one table and only those records from the other table where the joined fields match.
C)The LEFT JOIN clause is used when you want to return all rows in the left table,even if no matching rows exist in the right table.
D)The FULL OUTER JOIN clause is not supported in Microsoft Access.

Question

Quizplus · Accepted Answer

An OUTER JOIN does not require rows to meet WHERE or HAVING conditions to return all rows from one table; it returns all rows from one table and the matched rows from the other table, or NULLs if no match is found.

Which of the Following Is NOT True Regarding Outer Joins