有订单表orders(oid,odate,cid), 其中oid是订单号,odate是订单日期,cid是客户编号; 订单详细信息表orderitems(oid,pid,quantity);其中pid是商品编号,quantity是数量。 查询购买商品编号为“101”商品的顾客编号及订单日期。SQL语句为( ) A. select cid,odate from orders where oid in (select oid from orderitems where pid='101'); B. select cid,odate from orders where oid all (select oid from orderitems where pid='101'); C. select cid,odate from orders where oid any (select oid from orderitems where pid='101'); D. select cid,odate from orders where oid (select oid from orderitems where pid='101');