DELETE ORD, DTL
FROM ORDERS AS ORD
INNER JOIN ORDERS_DTL AS DTL
where ORDER_DATE =< '2010-12-31'
and ORDER_DATE >= '2010-01-01'