（124）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:

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）

解析：

Promotions表和sales表进行连接时，除了要指定时间在相应的范围外，还要指定promo_id相等。

ITPub博客

OCP 1Z0-051-124

最新文章