（128）View the Exhibits and examine the structures of the CUSTOMERS, SALES, and COUNTRIES tables.

You need to generate a report that shows all country names, with corresponding customers (if any) and sales details (if any), for all customers.

Which FROM clause gives the required result?

A. FROM sales JOIN customers USING (cust_id) FULL OUTER JOIN countries USING (country_id);

B. FROM sales JOIN customers USING (cust_id) RIGHT OUTER JOIN countries USING (country_id);

C. FROM customers LEFT OUTER JOIN sales USING (cust_id) RIGHT OUTER JOIN countries USING (country_id);

D. FROM customers LEFT OUTER JOIN sales USING (cust_id) LEFT OUTER JOIN countries USING (country_id);

答案：（C）

解析：

即所有的国家需要全部显示。Customers表与sales表连接时，用户需要全部显示。

ITPub博客

OCP 1Z0-051-128