user_id  start_date  end_date
-------  ----------  --------
1        1-Apr-2007  31-Mar-2008
1        1-Jun-2008  31-Dec-2008
2        1-Jan-2008  31-Dec-2008
...

tran_id  tran_date
-------  ---------
100      1-Mar-2008
101      4-Mar-2008
102      15-Apr-2008
103      12-May-2008
104      6-Jun-2008
...

select *
from transaction
where tran_date between ? and ?
and exists (
select *
from user
where user_id = ?
and tran_date between start_date and end_date);