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:
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.
Explanation:
