2. From the tables [Order Details] and Orders - List any products that have not appeared on an order in 1996 (subquery w

Business, Finance, Economics, Accounting, Operations Management, Computer Science, Electrical Engineering, Mechanical Engineering, Civil Engineering, Chemical Engineering, Algebra, Precalculus, Statistics and Probabilty, Advanced Math, Physics, Chemistry, Biology, Nursing, Psychology, Certifications, Tests, Prep, and more.
Post Reply
answerhappygod
Site Admin
Posts: 899603
Joined: Mon Aug 02, 2021 8:13 am

2. From the tables [Order Details] and Orders - List any products that have not appeared on an order in 1996 (subquery w

Post by answerhappygod »

2. From the tables [Order Details] and Orders - List anyproducts that have not appeared on anorder in 1996 (subquery with [NOT] IN) (1705records).
3. From the tables Products and [Order Details] - List alldetails of products that have been sold (any date). We need this torun fast, and we don't really want to see anything from the [orderdetails] table, so use EXISTS (77 records).
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!
Top
Post Reply

Return to “Archived Questions & Answers”