该博客讨论了一个Oracle OCP-1Z0-051考试中的JOIN查询问题。在尝试从PROMOTIONS, SALES, 和CUSTOMER表中获取促销名称和客户名称，条件为产品在促销期间销售且在2007年10月30日前，原始查询因缺少关键的JOIN条件导致结果不正确。博主通过创建和填充表来演示错误，指出需要添加促销ID（promo_id）的匹配条件以得到正确结果。"
129174311,9332156,VXLAN-BGP EVPN部署详解：分布式网关实践,"['网络', '分布式', 'VXLAN隧道']
一、原题
二、题目翻译
View the Exhibit and examine the structure of the PROMOTIONS, SALES, and CUSTOMER tables.
You need to generate a report showing the promo name along with the customer name for all products that were sold during their promo campaign and before 30th October 2007.
You issue the following query:
SQL> SELECT promo_name,cust_name
FROM promotions p JOIN sales s
ON(time_id BETWEEN promo_begin_date AND promo_end_date)
JOIN customer c
ON (s.cust_id = c.cust_id)
AND time_id < '30-oct-2007';
Which statement is true regarding the above query?
A. It executes successfully and gives the required result.
B. It executes successfully but does not give the required result.
C. It produces an error because the join order of the tables is incorrect.
D. It produces an error because equijoin and nonequijoin conditions cannot be used in the same SELECT statement.
答案：B
You need to generate a report showing the promo name along with the customer name for all products that were sold during their promo campaign and before 30th October 2007.
You issue the following query:
SQL> SELECT promo_name,cust_name
FROM promotions p JOIN sales s
ON(time_id BETWEEN promo_begin_date AND promo_end_date)
JOIN customer c
ON (s.cust_id = c.cust_id)
AND time_id < '30-oct-2007';
Which statement is true regarding the above query?
A. It executes successfully and gives the required result.
B. It executes successfully but does not give the required result.
C. It produces an error because the join order of the tables is incorrect.
D. It produces an error because equijoin and nonequijoin conditions cannot be used in the same SELECT statement.
答案：B
二、题目翻译
最低0.47元/天 解锁文章
1952
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
