2. From the tables [Order Details] and Orders - List any products that have not appeared on an order in 1996 (subquery w
Posted: Sun Jul 03, 2022 5:23 pm
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).
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).