有orders表和order_items表,其中orders表中order_id为主键,order_items表中order_id为外键参照orders表的order_id列,并且允许级联删除,下列哪个delete语句可以成功运行?
A.
delete order_id from orders where total>1000
B.
delete from orders where total>1000
C.
delete from orders where (select order_id from order_items)
D.
delete from orders, order_items were orders.order_id=order_items.order_id