Experiment 16-09 in TestDB: Query order "16M DRAM" goods ...

TestDB is the product sales database, please in the TestDB: the query ordered both "16M DRAM" goods, but also ordered "1.2GB HDD" commodity customer number, order number and order amount.

Select DISTINCT Cust_id,b.order_no,tot_amtfrom sales b,product a,sale_item cwhere a.prod_id=c.prod_id and b.order_no = c. Order_no and prod_name = ' 16M DRAM ' andb.  Order_no in (select B.order_no from Product a,sales b,sale_item c where  b.order_no = C.order_no and a.prod_id=c.prod_id and prod_name = ' 1.2GB hdd ')

　　

Experiment 16-09 in TestDB: Query order "16M DRAM" goods ...