有订单表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');