DELETE FROM 
(select *
FROM ORDERS
LEFT JOIN ORDERS_DTL ON ORDERS.ORDER_NO = ORDERS_DTL.ORDER_NO
WHERE ORDERS.ORDER_DATE 
BETWEEN '2010-01-01 00:00:00' AND '2020-12-31 23:59:59'
)