也许是一个子查询:
select * from order o where o.order_num in (select distinct order_num from order where tstamp between '2010-01-03' and '2010-01-09')

也许是一个子查询:
select * from order o where o.order_num in (select distinct order_num from order where tstamp between '2010-01-03' and '2010-01-09')