DELETE FROM ORDERS
WHERE ORDER_NO IN (
    SELECT ORDERS.ORDER_NO
    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'
)