with a as (
    select *
    from ORDERS
    left join ORDERS_DTL on ORDERS.ORDER_NO = ORDERS_DTL.ORDER_NO
)
DELETE
FROM ORDERS
where ORDER_DATE between '2010-01-01' and '2010-12-31'