You are trying to create a query that will show you the product id, product name

Question

You are trying to create a query that will show you the product id, product name and order id for all of the orders in your database. However, your partial output looks like the following: select product ID, product Name, Order Key from product, order detail product key product Name Order Key What is wrong with your query? There is nothing wrong with this query. The query is missing an order by statement. The query is missing a group by statement. There is a cartesian product created by the improper join of product with order detail.

Explanation / Answer

question 3:

answer:

There is a cartesian product created by the improper join of product with order detail.                                       

Related Questions

Navigate

• Browse (All)
• Browse Y
• Subjects

---