delete
    ORDERS as ord
    ,ORDERS_DTL as ordd
from
    ord
    
inner join 
    ordd on ord.ORDER_NO = ordd.ORDER_NO

where
    ord.ORDER_DATE = between '2010-01-01' and '2010-12-31';