You have been asked to fix some inconsistencies in a database. After running the following query,

select productid     , price from order_item;

you notice that there are product id's listed in your result set that do not match the products in your database. As this provides an inaccurate report, how do you fix this?

Answer rating: 100% (QA)

If youve run a query like SELECT productid price FROM orderitem and youve identified that there are product IDs in the result set that do not match th... View the full answer