run this sql statement;
select id_number,description,price
from inventory
where manufacture_id in
(select manufacture_id
from inventory
where price>8.00
or quantity >1000);
which values will be displayed?
答案:
C.The id number,description,and price of items in inventory that are
priced greater than 8.00 or that have a quantity value granter than
1000 and have a manufacture id value.
D.The id number,description,and price of items in inventory that were
manufactured by a manufacture whth items in invertory that are priced
greater than 8.00 or with items in invertorythat are priced greater
than 8.00 or with items in inventory that have a quantity value granter
than 1000.
我选的是C,可正确答案是D,不明白是为什么?
|