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.
A
You might also like to view...
The ________ selection in the Insert group on the Header & Footer Tools Design tab provides quick access to commonly used fields, such as Author and File Name
Fill in the blank(s) with correct word
A technician is using the Security tab in the Properties dialog box in an attempt to remove the inherited status from a file’s permissions but cannot locate where to make the change. Which of the following steps should the technician take to make this change?
A. Click the Sharing tab and click Advanced Sharing. B. Click the Administrator user name and click the Edit button. C. Click the Advanced button to open Advanced Security Settings for the file. D. Click the Previous Versions tab, highlight the file, and click Restore.