Consider the following query: The query retrieves: a. The number and name of all the products with

Question:

Consider the following query:

SELECT P.PRODNR, P.PRODNAME FROM PRODUCT P EXCEPT SELECT POL.PRODNR FROM PO_LINE POL

The query retrieves:

a. The number and name of all the products with no outstanding order.

b. The number and name of all the products that are ordered.

c. The query will not execute because both queries do not select the same columns.

d. The query will not execute because both queries do not select the same rows.

Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For  book-img-for-question
Question Posted: