Author Question: Which of the following is NOT true regarding outer joins? A) The OUTER JOIN clause returns all ... (Read 44 times)

theo · **on:** Aug 28, 2018

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 2

The ________ function truncates the decimal and returns only the numbers to the left of the decimal.

Fill in the blank(s) with correct word