thx,Lowell ,but that's not what i want.

in the table ,column b and e stand for begin and end of a member segment , and what i want is deleting the...

man ,i'm confused:hehe:.

to find all orders that have been received and not yet filled for a given date, shouldn't the query be like this:

SELECT order_number

FROM order

WHERE order_received <= given_date

AND (order_filled...