128.You need to generate a report that shows all country names, with corresponding customers (if any

最新推荐文章于 2022-02-15 17:07:09 发布

今年我18

最新推荐文章于 2022-02-15 17:07:09 发布

阅读量1.2k

点赞数 1

分类专栏： 1z0-051 文章标签： 1z0-051

本文链接：https://blog.csdn.net/dwj19830118/article/details/50825432

版权

1z0-051 专栏收录该内容

175 篇文章 1 订阅

订阅专栏

128.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
解析：题目要求可以看到两个all分别是显示所有的country names和customers，因此排除A，B，D，