Reply
Fri 19 Jun, 2020 09:39 am
Based on the tables below:
PRODUCT(*PROD_ID*,PROD_NAME,SUPPLIER_ID,UNITPRICE,PACKAGE,ISDISCONTINUED)
ORDER ITEM(*ID*,ORDERID,PRODUCTID,UNITPRICE,QUANTITY)
You are required to list products with order quantities greater than 100 using Type 1 Nested query.
USING THIS FORMULA:
1. SELECT column-names
2. FROM table-name1
3. WHERE value IN (SELECT column-name
4. FROM table-name2
5. WHERE condition)
@nzarar 17,
select prod_name from product where productid in
(select prod_id from item where quantity > 100);
this is what i've done. Can you guys correct me if I'm wrong